2 min video about the SQL_Compare
- by CatherineRussell
It is nice to start blogging again! I am working on new project in a small company now.
We do not have a full time database admin.
I have to cover multiple roles: getting requirements, writing docs and creating diagrams, designing app, writing code, testing and DBA role.
I am not a DBA. But, I have to do day to day database changes: adding new new columns and tables.
Check out 2 min video about the SQL_Compare. This tool saves time by automatically comparing and synchronizing database schemas; eliminate mistakes migrating database changes from dev, to test, to production; speed up the deployment of new database schema updates; generate T-SQL scripts to update one database to match the schema of another; find and fix errors caused by differences between databases; keeps an accurate history of all previous database records.
http://www.red-gate.com/products/SQL_Compare/index.htm