Data transfer
Database
2
Posts
2
Posters
0
Views
1
Watching
-
i am planning to do an extensive data transfer from tables in one database to different database that has a different table structure can someone point me in the direction i should be reading up where i can accomplish this? kenny
-
i am planning to do an extensive data transfer from tables in one database to different database that has a different table structure can someone point me in the direction i should be reading up where i can accomplish this? kenny
INSERT INTO Table1 ([Table2] (Field1,Field2) ) SHAPE { OPENQUERY([Adventure Works DW],'SELECT Field1,Field2 FROM database.Table') As Table2 }
Best Regards, Chetan Patel