[dba-SQLServer] Move table between databases

jwcolby jwcolby at colbyconsulting.com
Fri Jun 29 12:28:08 CDT 2007


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 




More information about the dba-SQLServer mailing list