Feature Request (?) for SQL 2005

wavesmash

SQL 2005 introduces new system tables & stored procedures.

sysdiagrams
sp_alterdiagram
fn_diagramobjects

etc.

Is there a way to filter these out?

Also, Sql 2005 uses the syntax DEFAULT ((1)) while Sql 2000 uses DEFAULT (1). Whenever I do a synch on a table which has this type of value, it never appears to synch up.

Roger

Hi!

We have the same probleme as wavesmash. How can we fix that?

Thans for your reply!

Regards

Roger

Neil Davidson

SQL Compare 4.0 (in beta - http://www.red-gate.com/products/sql_bu ... e_beta.htm) will take account of the extra brackets in SQL 2005 and not mark those two defaults as different (although they will still appear different in the side by side text, since this is essentially just a textual diff).

Neil Davidson

The new system objects will be filtered out in the final release of 4.x as well.

Roger

Hi Neil

Thanks for your reply!

Ok, we tested the beta and everything works fine. A few weeks ago, we bought the toolkit for internal developments. Could you tell us, when the official release of sql-compare 4.0 (toolkit) will be launched?

regards

roger

Brian Donahue

Hello Roger,

SQL Toolkit will be released at the same moment as SQL Bundle 4.0, since the components are integrated into same. This should happen in a few weeks. Sorry -- there is no firm date yet.