Results 1 to 5 of 5

Thread: SQL DB Tools

  1. #1
    Join Date
    Apr 2004
    Location
    Jersey
    Posts
    9

    Unanswered: SQL DB Tools

    Can anyone recommend any tools or bundles that are out there for MSSQL databases used for comparing and syncronizing stucture, data, stored procs, etc.

    I'd like to hear about any and all.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    http://www.red-gate.com/sql/summary.htm

    Or you can write your own using sql again INFORMATION_SCHEMA views...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2004
    Location
    Jersey
    Posts
    9
    Could you elaborate a little more on the INFORMATION_SCHEMA views please? Nothing too indepth, just a quick once over if you don't mind.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Open QA and cut and paste this

    USE Northwind
    GO

    SELECT * FROM INFORMATION_SCHEMA.Tables

    Look it up in BOL for more details...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2004
    Location
    Jersey
    Posts
    9
    Thanks Brett!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •