This should be easy because I'm sure it's an everyday kind of task. I've just never had to do it before. I am using an .adp project with SQL Server 8. A couple of months ago I made a copy of one of our production databases in order to make some changes. The changes involved major table restructuring for a few tables, some new tables, procedures, views and forms. We used this same development database for testing also. Now I am ready to implement the new changes. What's the best way, given that database activity has continued in the production environment?
Basically, there are about five tables in the production environment that have continued to be updated. Seems like the simplest thing to do would be to move just those 5 tables over to the test environment and then make the test environment the new production environment. But I'm not sure how to do this and retain the contraints etc. Can I just empty said tables in test database and export/append to tables from production database? But the constraints ... Do I have to remove constraints and recreate them (or I guess I could generate a script) afterwards? Fortunately, these tables are not the tables that underwent restructuring.
Or would it be best to try to bring all my changes from test over to production?
Or is there a prescribed way to accomplish all this that I don't know about?
Thanks for your help.