Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
garyiskidding
Starting Member
1 Post |
 Posted - 2008-11-17 : 04:11:24
|
| Hi,I have to migrate some tables from one SQL Server DB to another. The data in the table(s), in the source DB needs to be grouped /modefied/changed as per the new table design (or some business logic) in the destination DB.Please suggest how can this be done, and if there are tools within SQL Server that support such data migration.ThanksGaurav |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 04:20:28
|
| i think what you need to create a SSIS package which extracts data from source db, does all your logic and dumps data to destination. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 04:21:05
|
| And if dbs are in same server, you can even write a sql procedure to achieve what you want |
|
|
|
|
|
|
Data Migration (with data changes)