Transfer database table between two sql server 2008

Hello there,

How can I transfer db tables between two sql server 2008 db which are on different networks.

cheers
Zolf
zolfAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Tony303Connect With a Mentor Commented:
For me. I'd just backup the database, take the .bak file to the other network and restore it.

But, if you are just wanting to do a couple of tables then you could export the data to a .csv say, move the csv's to the other network and truncate the tables, then use the import wizard to bring in the csv data.

I have a process that I have daily where I have data from one network exported as a bcp file, then zipped then put onto an FTP server. At my end, I have an SSIS package that gets the file from the FTP, unzips and then runs an import of the bcp files.
(a lot of setup, but since it is daily it is all automated now).
0
 
Tony303Commented:
Is this a one off? or a regular thing?
0
 
zolfAuthor Commented:
thanks for your feedback. I am developing a software and I need to keep transferring data to the client side once in a while for testing.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
zolfAuthor Commented:
cheers!!

>> I'd just backup the database, take the .bak file to the other network and restore it.
the problem I have is the db size is big and then I have unreliable internet connection.
0
 
Tony303Commented:
If your tables have ID's, how about getting the last ID from the destination table. Just export the source records with a greater ID?
0
 
zolfAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.