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
Technology Tips and News
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
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
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.