To find the Script difference between the two databases

  • Dear All,

    I have a requirement in which i have to determine the Script difference between the two given databases, so that i can run that script on the old database and use it as the updated one...

    I am working on .NET 3.5 and SQL Server Express 2005

    Your help is highly appreciated. I am looking in for a free ware or a tool which can help me in achieving this

    Regards

    Vathan

  • red gates sql compare is very good but it isnt free.

  • Dear iainthepitman,

    I visited that site and verified.. Even checked the review comments of that particular tool..

    But for my requirement i need a free ware....

    Thanks for ur reply

    Regards

    Vathan

  • Toad has one that is free to a certain number of objects. I think xSQL does also.

    If you have to do this more than once, I would recommend spending a bit of money - you get what you pay for.

  • Dear Michael,

    Being a .NET developer, can i able to create a tool to do this?

    If so how much time will it take to create a tool like this one..

    Regards

    Vathan

  • By looking at the xSQL GUI, I would have to say 4 developers and 2 QA people can build it in 6 months. However, I am probably underestimating some of the complexities.

  • Dear Michael,

    That was a great reply...

    Regards

    Vathan

  • Not sure what you want to compare exactly...

    Found the following two on codeproject.com

    Database compare: http://www.codeproject.com/KB/database/DBCOMPARE.aspx

    Schema compare: http://www.codeproject.com/KB/database/SideBySideSQLComparer.aspx

  • Dear Sunny,

    Thanks for your reply

    They were not matching my requirements...

    Looking out for a closer solution...

    Regards

    Vathan

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

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