VB.net Transfer very large SQL tables between databases

Hi

I want to build a VB.net windows form used to transfer tables of 50 to a 100 million records of data between two SQL databases. I have the connection strings for both databases. What VB.net code would I use to do this to ensure that either all the records go in (or not) in a Transact Rollback way?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I wouldn't develop nothing since Integration Services (SSIS) is a powerful ETL .NET tool.
Will save you hours of work as you can build the package and add it to SQL Server Agent as a job to run in a schedule basis.

Other option is to use the bcp utility. A SQL Server tool for bulk copy data. You can found more information about it here. After scripting the command you just need to schedule it using a tool like SQL Server Agent or the Task Scheduler from Windows.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if this is a "move of records", you should not do this with a vb.net application, but with sql run on the servers using linked servers
only this way you will get an efficient transfer ( SERVER1 => SERVER2 ) and garanteed transaction control instead of  this data transfer : SERVER1 => APPLICATION => SERVER2
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
This is an one shot only procedure or something that you'll do it more often? In a schedule basis, maybe?
There are some good options for importing data into a database but the solution depends on what are your needs.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi Vitor. That is a very good question. This is definitely not a one shot procedure. It will happen on a schedule basis.
Sorry Guy, I should have mentioned that
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
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.