[dba-SQLServer] Migrating tables to a new database

Mark Rider ridermark at gmail.com
Mon Jan 22 06:30:50 CST 2007


The way I have always handled the migration is to create a table in
the new DB with all of the indices and constratints and then used DTS
to import from the old database.

I am hoping someone will have a more elegant solution, but this has
always worked for me.

-- 
Mark Rider
http://dfwmdug.org

Don't anthropomorphize computers.
They don't like it.



More information about the dba-SQLServer mailing list