SQL Database comparison and script generation
Posted on 2011-02-28
I have a database in a dev environment that I have full access to and admin rights ,I also have another database in live environment that we only have view permissions on.
I am looking for a programme that I can use to compare the two database and that will generate update or create scripts so that I can give those scripts to the network administrator so he can run them on the live environment.
I am not to worried about the data all I am really interested in is updating the changes made to the tables and stored procedures. As well as creating any new stored procedures tables or views.
I dont mind buying a programme or using a free programme