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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-08-09 : 11:12:12
|
| Hi,I have to import data from an old database to a new database that has been normalised so as a result there are more tables and columns from tables in the old db have been moved to new tables in the new db.What is the best tool to import the data from the db to the new db? Should i use SSIS for that? If yes what are issues that i should be aware of or important things i need to know?Also, i need to have the application that i build available whenever data needs to be imported. Is SSIS good for this task?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
|
|
import from database to database