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