1. SQL Compare is the industry-standard tool for comparing and synchronizing SQL Server database schemas. It's used by over 200,000 developers, DBAs and test engineers worldwide because it's easy to use, it's fast, and it saves time.
Whether you are working with live databases, database snapshots, object SQL scripts under source control or an earlier backup, SQL Compare will help you compare and synchronize database changes quickly, simply and with zero errors.
Read the whitepaper on database development and discover how SQL Compare can save you astonishing amounts of time, whatever development model your team prefers to use. SQL Compare ensures accurate, fast results with maximum end-user flexibility.
2. SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups, compiling audit trails of missing or changed data, and SQL scripts under source control. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast.
With SQL Data Compare's granular SQL change-scripts you can now restore damaged or missing data to a single row, without the need for a full database recovery, and that means you can fix database problems even faster.
3. SQL Packager works by scripting and compressing the entire database ? schema and data together ? and packaging it up as a deliverable .exe file. It does this by scripting separate transactions for schema and data respectively. Highly customizable options enable you to generate package scripts to exactly fit your needs.
When migrating databases, all schema objects, all new tables and their data as well as data with unique indexes or constraints are also scripted.
Installing, updating, or distributing your database now becomes a simple point-and-click procedure. Deploy SQL Server databases, and your applications that depend on them, with no manual scripting. Exploit the command line options to automate the installation of database updates remotely.
By letting you compress your packaged database, you can reduce storage overhead and distribute it faster and more easily. SQL Packager also makes it easy to archive your database, and is an excellent solution for making a backup of your database where you don't have SQL Server administration rights.
You can read how iCOMcept in Aachen, Germany, minimized their application deployment window using SQL Packager.
4. SQL Dependency Tracker allows you to dynamically explore all your database object dependencies, using a range of graphical layouts. You can analyze large Microsoft SQL 2000, 2005 and 2008 databases and produce an easy-to-read dependency diagram for thorough pre-impact analysis of all database changes. The fast and simple visual rendering of database structures includes a draggable "overview" window to enable very rapid navigation through large databases, plus clipboard functions for saving and printing your target diagrams.
Tracking dependencies by hand traditionally relies on the personal knowledge of whoever designed the database in the first place. If that person has moved on or is indisposed, business continuity suffers. Automated SQL Server dependency tracking and reporting minimizes downtime and ensures business continuity.
