Advise please

[newboy18]

I need to make a lot of changes to a live database, can I prepare the updates using a copy of the original and then just import them when convenient, if so how do I deal with changes to the tables?

 

[SBendBuckeye]

I would do update SQL on a copy of your database database to ensure everything is working correctly. Then when you do your live update you can create a second set of queries to find the ones you didn't update. To do this, save the primary keys of the table in question and then use those as a subselect for your second query. You would do something along the lines of the following:

Select field1, field2 from table1 where primarykey not in (Select primarykey from savedupdatedtable);

Good Luck!