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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    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