Doris Manning
mikedorism at verizon.net
Fri Jun 29 14:10:33 CDT 2007
You can transfer the table to the new database using the DTS Export Wizard. Doris Manning Database Administrator Hargrove Inc. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, June 29, 2007 1:28 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Move table between databases I need to move a "raw data" table out into it's own separate database file. One way I could do this is to copy the database file, then go in and delete all the other tables in that database. What I would prefer is to somehow copy the table itself, INCLUDING ALL INDEXES, out to another database. Is that possible? If so how? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com