[ShadoCat]

Speaking of automated processes, I just found this:

http://access-data-transfer-assistant-2 ... picks.com/

It claims to be a way of distributing .mdb updates.

[Erik L]

Speaking of automated processes, I just found this:

http://access-data-transfer-assistant-2 ... picks.com/

It claims to be a way of distributing .mdb updates.

The biggest issue is schemata changes. Without those, upgrading would be very simple. I'll send them an email and see if it handles them...

[Beersatron]

I use SQLDiff at work, you can run two different comparisons. One on the actual data stored in each table and then one on the structure of each table. It will then provide you with the SQL so you can run it yourself or you can just click on and let it do the changes for you.

Pretty sure there is a 30 day trail and then after that you need to pay - but it helps us alot at work especially atm since in the last two weeks I have created about 10new tables and views and will be editing stored procs. This just takes the hastle away

http://www.apexsql.com/sql_tools_diff.a ... DAodBSaMQQ