Click here to Skip to main content
15,849,328 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have 12000 records in local server and i want to copy those record into remote server how is it possible plz try to solve my question through sql query i do not want backup and restore again and again.Thanks in advance

Try creating a SSIS or DTS package for this.

Check this.[^]

Or you can use

SQL Server Management Studio and do an Export Task by right-clicking the database and going to Task>Export and select source and destination.
Share this answer
If you have a few tables you could just use
select * into [server2.table1] from server1.table1.

If you have a large number of tables, you would need to build an automated script.
Share this answer
You could use linked servers then you just need to add the server in your table name
Share this answer
You can do this with sql server import/export wizard
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900