mbs2000
asked on
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?
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?
If the two databases are on different servers, then yes - DTS or SSIS (2005/8) is a workable solution.
ASKER
Thanks, they are on two different servers but I would be testing with backups on the same server. Would DTS still work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.