[dba-SQLServer] Migrating tables to a new database

JWColby jwcolby at colbyconsulting.com
Mon Jan 22 05:41:06 CST 2007


Is it possible to migrate a table, complete with all indexes and any other
attributes to another database?  Whenever I do an Import Data it just kind
of does a generic "here's your data" kind of thing.
 
The business I am getting into involves taking lists of addresses along
which includes what I call survey data.  There is a TON of preprocessing
involved getting the addresses run through a set of processes to check with
the US Postal Service to ensure that the address is deliverable - CASS (does
the address conform to the USPS system), DPV (Delivery Point Validation -
the address exists), and NCOA which means essentially "have they changed
addresses".  Given all of the preprocessing, I really want to do this out in
a separate database for each list, where when I am finished a completely
processed set of records exists.
 
Having done all of that, I need to merge the data into a master database of
people, valid addresses, and people at addresses.  For technical reasons I
need to be able to track where people have lived.
 
I have processed a huge list and now have a database with information about
the people in THIS LIST.  I am considering building up my People / Address /
PeopleAtAddress tables inside of this first list database, and then later
migrating these three tables out to a separate database.  I do not wish to
do that however if I am going to lose all of the indexes I set up etc.
 
Any pointers on this matter?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the dba-SQLServer mailing list