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?
 
Tony303Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.