Eric Barro
ebarro at verizon.net
Fri Jun 29 14:24:28 CDT 2007
1. Script the table including indexes. 2. Import the data to the other database. -----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 10:28 AM 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