SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Copy data between 2 networks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kimi86
Yak Posting Veteran

62 Posts

Posted - 10/15/2013 :  09:37:08  Show Profile  Reply with Quote
Hi Friends,
I have around 100 tables to copy from one server to another. The problem is that these 2 servers are not in the same network. Is there any way in which I can achieve this. May be copy data in a disc and and then copy it to the other servers.Please could you suggest few ways of doing this.

Thanks

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 10/15/2013 :  10:46:21  Show Profile  Reply with Quote
If those 100 tables constitute most of the database, backing up the database, restoring it on the remote server and then copying would be an option.

If the 100 tables is only a small portion of the database, copy those tables to a new database on the local server, backup this new database and restore on the remote server.

You could export the data to flat files and then move them over to the remote server and import them, but I would prefer the other approaches.
Go to Top of Page

Kimi86
Yak Posting Veteran

62 Posts

Posted - 10/16/2013 :  01:58:43  Show Profile  Reply with Quote
quote:
Originally posted by James K

If those 100 tables constitute most of the database, backing up the database, restoring it on the remote server and then copying would be an option.

If the 100 tables is only a small portion of the database, copy those tables to a new database on the local server, backup this new database and restore on the remote server.

You could export the data to flat files and then move them over to the remote server and import them, but I would prefer the other approaches.





the 100 table make about 8 GB. This is what I am planning to do.

Step 1. Copy the 100 tables to a new database in the local server
Step 2 -I take full back up of this database (with only those 100 tables)
Step 3 - I somehow place the .bck and .trn files (I mean data and log files) generated from step 2 in the new network . I can do this through USB or any other mechanism
Step 4 - I restore these files in another database in the new network

Please suggest if this will work




Edited by - Kimi86 on 10/16/2013 01:59:25
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 10/16/2013 :  08:34:45  Show Profile  Reply with Quote
quote:
Originally posted by Kimi86

quote:
Originally posted by James K

If those 100 tables constitute most of the database, backing up the database, restoring it on the remote server and then copying would be an option.

If the 100 tables is only a small portion of the database, copy those tables to a new database on the local server, backup this new database and restore on the remote server.

You could export the data to flat files and then move them over to the remote server and import them, but I would prefer the other approaches.





the 100 table make about 8 GB. This is what I am planning to do.

Step 1. Copy the 100 tables to a new database in the local server
Step 2 -I take full back up of this database (with only those 100 tables)
Step 3 - I somehow place the .bck and .trn files (I mean data and log files) generated from step 2 in the new network . I can do this through USB or any other mechanism
Step 4 - I restore these files in another database in the new network

Please suggest if this will work





That should work. As the final step, you would want to copy the data from the restored database to your destination tables in the target database.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000