How to dump all tables data from read only db to other db

Hello every one,

How to dump all tables data from read only db to other db having same structure?.

Is there any commands available in sql server or need to write console app in .net, please suggest me your ideas.

T

July 19th, 2013 1:26am

Hello Siva,

You can use three-part qualifier in the manner [Database].[Schema].[Object] to address several databases in one query. To copy data from a source to a destination database you can use such an INSERT command:

INSERT INTO DestinationDB.dbo.Table1
    (Col1, Col2, ....)
SELECT Col1, Col2, ...
FROM SourceDB.dbo.Table1

Free Windows Admin Tool Kit Click here and download it now
July 19th, 2013 2:52am

hi Siva

 if you have source and destination database  in same instance use normal insert query with suggest by Olaf,but source and destination database different instance or server please go with options such as

  1.Linked Server

  2.Import and Export wizards.

  3.SSIS

  4.OPENROWSET.

Please mark as ANSWER, if its helpful to you.

July 19th, 2013 2:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics