Jim Lawrence
accessd at shaw.ca
Mon Jan 22 13:08:16 CST 2007
Mark: I use a similar method... Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark Rider Sent: Monday, January 22, 2007 4:31 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Migrating tables to a new database 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. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com