SQL Compare 6.0 beta – read and sync to and from SQL scripts

Comments 0

Share to social media

We have just released the first public beta for SQL Compare 6.0. The full version of SQL Compare 6.0 is scheduled for release towards the end of June 2007. For the forum and download information visit http://www.red-gate.com/MessageBoard/viewforum.php?f=65

 

So what is new in SQL Compare 6.0 beta?

SQL Compare 6.0 beta introduces a new data source. Until version 5.3 SQL Compare could compare and synchronize live SQL Server databases and SQL Compare schema snapshot files. Version 6.0 extends this with creation scripts. You can now specify a filesystem folder with creation SQL files. These are read in as a virtual database and can be compared with another database, or creation SQL files.

This is handy when you have some SQL scripts, and want to execute them in dependency order.

 

But in SQL Compare 6.0 you will also be able to synchronize to scripts. This means that if you develop on a live database, you can update a set of SQL script files that represent the database schema. This opens doors for source control for your database.

In addition to comparing and synchronizing to and from object-level SQL scripts, SQL Compare 6 contains many enhancements to its user interface. We have improved searching in the comparison results as well as in the detailed differences panels. We have also improved our project selection dialogs.

Load comments

About the author

András Belokosztolszki

See Profile

András Belokosztolszki is a software architect at Red Gate Software Ltd. He is a frequent speaker at many UK user groups and events (VBUG, NxtGen, Developer’s Group, SQLBits). He is primarily interested in database internals and database change management. At Red Gate he has designed and led the development of many database tools that compare database schemata and enable source control for databases (SQL Compare versions 4 to 7), refactor databases (SQL Refactor) and show the history of databases by analyzing the transaction log (SQL Log Rescue). András has a PhD from Cambridge and an MSc and BSc from ELTE, Hungary. He is also a MCSD and MCPD Enterprise. See my blogs on simple-talk.

András Belokosztolszki's contributions