Subject | how find databases objects differences |
---|---|
Author | ndirondello marco |
Post date | 2012-10-16T09:12:35Z |
hi all, i have same remote firebird servers (2.5) which i cannot access directly from my local machine (ie i access them using same remote desktop bridges).
i need to update the remote database objects (table structure/store procedure/etc) but not data (every db have his local data), i will make the update by hand so i can manage correctly every changes (for example i can corretly set the values when a new colum must be added).
at the moment i generate a text file with the dll to recreate an empty database and i check in sequence every single object of the remote db with the dll to find the differences.
i want know if exists a faster way to get the differences using the text file with the dll to generate the db (or an empty database with the update structure or what you want) and the remote database.
in the remote machine i had only flamerobin and i cannot install other applications.
thanks for your suggestions
i need to update the remote database objects (table structure/store procedure/etc) but not data (every db have his local data), i will make the update by hand so i can manage correctly every changes (for example i can corretly set the values when a new colum must be added).
at the moment i generate a text file with the dll to recreate an empty database and i check in sequence every single object of the remote db with the dll to find the differences.
i want know if exists a faster way to get the differences using the text file with the dll to generate the db (or an empty database with the update structure or what you want) and the remote database.
in the remote machine i had only flamerobin and i cannot install other applications.
thanks for your suggestions