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 |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2009-08-19 : 10:41:18
|
| I'm doing db migration in SQL2005.I like to move some columns from existing database to new database.db1.table1.col1 to db2.table2.col2How can I do that. Can I use DTS ?What is the best way ?thanks. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-19 : 11:23:35
|
| You can use the wizard to import the data. It's easy. Or BCP.Or SSIS.The best way would depend on (re-)use/deploy/data volume/etc |
 |
|
|
|
|
|
Help to move data