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:
Hi,
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
Posted

Try creating a SSIS or DTS package for this.

Check this.

http://msdn.microsoft.com/en-us/library/ms141026.aspx[^]

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
 
v2
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
 
v2
You could use linked servers then you just need to add the server in your table name
myserver2.mydatabase.myshema.mytable
 
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