Post reply

Does SQL Server 2005 has Schema comparison utility/tool ?

  • May 15, 2009 at 6:57 am

    #131355

    Hello,

    I know there is a way to do schema comparison between two databases. As a BI developer, I do not have the tool except SQL Server Business Intelligence Studio. However, when I talked to our SQL DBA if he has any tool at his end, his repose “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:55 am

    #995345

    Somebody has suggested me to buy, but 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 8:46 am

    #995394

    I find the StarInix tool quite good (freeware).

  • May 15, 2009 at 12:51 pm

    #995593

    Thanks SSC Rookie, will try that out!

  • May 15, 2009 at 1:18 pm

    #995618

    without budget for software you can also script this type of task looking at the INFORMATION_SCHEMA views. You can also cross instances using linked servers. I'm guessing there are plenty of script already written out there as well

  • May 16, 2009 at 3:30 am

    #995841

    How about DbDiff:-

    http://dbdiff.codeplex.com/

  • May 18, 2009 at 12:07 pm

    #996546

    Thanks Ted - will look that!

  • May 18, 2009 at 12:14 pm

    #996548

    Thanks Ted. will try this out

  • May 19, 2009 at 7:38 am

    #996957

    Many of the tools you can't afford have free trial versions available that you could use for a one-time job. Sometimes they are impressive enough that the beancounters can be convinced to write a check.

    RedGate's SQL Compare is worth taking a look at. I'm not a saleman, just a satisfied user.

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

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