Post reply

Does SQL Server 2005 and schema comparison

  • May 15, 2009 at 7:14 am

    #209775

    Hello,

    I know there is a way to do schema comparison between two databases. As BI developer, I do not have the tool except SQL Server Business Intelligence Studio. However, when I talked to our SQL Server DBA if he has any tool at his end, his reponse “Sorry, we do not have any tool” . I thought SQL Server has a tool do perform schema comparison? Is there any free tool out there I might try ?

    JJ

  • May 15, 2009 at 7:18 am

    #995298

    Red gate offer a tool for comparing SQL Server database schema, its very well priced at $245 too

    I'm not aware of any free tools, although (and without wanting to sound like an advertiser) $245 is pretty much free!

  • May 15, 2009 at 7:53 am

    #995341

    Thanks Samuel , thanks for your suggestion. This comparison will be done only this time. We do not have budget to spend that kind of money. This is non-profit Org. I am quite sure that MS SQL 2005 has this utility, I would think I need to convince our volunteer DBA to spend sometime to figure this out. Any thought on this?

  • May 15, 2009 at 7:57 am

    #995347

    If you're a non-profit org then it might be worthwhile having a nice word with red-gate 🙂

    have a look here:

    http://www.databasejournal.com/features/mssql/article.php/3594926/SQL-Server-2005-TableDiff-Utility.htm

    for a table diff utility

  • May 15, 2009 at 12:52 pm

    #995596

    Thanks Samuel, will try that out!

  • May 15, 2009 at 4:48 pm

    #995753

    Redgate provides a fully functional trial version that lasts for 30 days. Who knows - if you download the trial and show it to the right people, they may just like it enough to purchase it.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • May 17, 2009 at 4:39 am

    #995961

    How about this one:-

    http://opendbiff.codeplex.com/

  • May 25, 2016 at 7:01 am

    #1881306

    I realise this is an old post but if anyone is looking for something like this then I have developed a software tool that will perform schema comparisons between two databases and it is available for free as a beta release.

    You can download SQLC here http://sqlc.azurewebsites.net/[/url]

    I am still actively developing this tool as a beta release so if you find any bugs then let me know and I will fix them as soon as possible.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply