1
I had some problems recently when making modifications in the type approval environment and for bureaucratic reasons these modifications could not be inspected in the production environment and were made in the wrong way, causing a delay in identifying the problem.
To avoid this I would like to know if there is any ideal way to proceed in these cases. In the specific case of SQL Server, it is possible to create a query that can compare two databases and perform the removal, addition and/or modification of fields and tables.
In this case I would just pass the query to the BD maintainer and it would run, avoiding errors.
This tool generates the update query or does the job through click interactions?
– Joao Paulo
I already found it here, thanks: Click the Generate Script button (the Fourth one from the left) on the Toolbar for the Schema Compare window.
– Joao Paulo
Can be done by script too, if necessary, but if you have access to both Databases without restrictions, you can do everything by graphic mode.
– Leonel Sanches da Silva
I do not know if I ask another question, what do you think? I would like to know this also for Oracle Bases.
– Joao Paulo
Yes, better another, to maintain the consistency of Tags.
– Leonel Sanches da Silva
On Oracle I think Sql Developer does .... http://blog.devart.com/comparing-two-oracle-schemas-is-simple-now.html
– Motta