Home Transfer specific data from one server to another
Reply: 0

Transfer specific data from one server to another

user604
1#
user604 Published in June 19, 2018, 6:15 pm

I have 2 different sql servers (2 different databases). The 2 servers have the same tables. Now I want to transfer from Server 1's Person table to Server 2's Person table only the records with ID between 1.000 and 50.000. How could I do it in the easiest way ?

Tried with Generate Scripts, but there isn't an option to select just those IDs, the script transfers all the records. Tried by using a SELECT statement on Server 1 and exporting the data as CSV, then importing the CSV file on Server 2, but apparently there are some problems because of the datetimeoffset fields...

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.332476 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO