What method would be best to use when transferring data between databases with have a different table structure

Being a beginner to SQL, i'm looking for a way to transfer data from one SQL DB to another. The tables and databases are structured differently but hold the same information.

Would DTS or using cursors in SQL be the best way to begin?

Not having much experience in wrtiting SQL, DTS looks the less trouble free solution?
mbs2000Asked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
DTS or DTSX has "Connection Manager" so you could run different task(s) inside the package against different servers.databases.tables
0
 
knightEknightCommented:
If the two databases are on different servers, then yes - DTS or SSIS (2005/8) is a workable solution.
0
 
mbs2000Author Commented:
Thanks, they are on two different servers but I would be testing with backups on the same server. Would DTS still work?
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.