How can we help you today? How can we help you today?

Feature Request (?) for SQL 2005

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.
wavesmash
0

Comments

5 comments

  • Roger
    Hi!

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

    Thans for your reply!

    Regards

    Roger
    Roger
    0
  • 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
    0
  • Neil Davidson
    The new system objects will be filtered out in the final release of 4.x as well.
    Neil Davidson
    0
  • 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
    Roger
    0
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.