Hi,

I would like to compare two database schemas and generate a script with the differences. I am not able to use reg gate due to trial period expiration. I have used the schema compare option in Visual Studio 2010. Is there any other tool to do the comparison and generate the script?

Thanks,

Preetha

Hello Preetha,

You can use the free tool MS SSDT = Microsoft SQL Server Data Tools; see How to: Use Schema Compare to Compare Different Database Definitions