How to generate schema comparison script automatically and deploy

See more:

SQL

Visual-Studio

server

Hi there,

I am working on one click publish thing in visual studio. In that I want to include Publish SQL as well. This is for deploying changes of schema without droping and creating tables and procedures again to save the data on production server.Auto script schema in Package/Publish SQL tab supports only initial deployment when you want to create everything from the scratch . To deploy changes to the schema I need to create a custom script.

Visual studio has got comparision tool in which we can compare two databases and export the script . Is there any way so that it will automatic refresh the schema comparison and changes the script which I can use in Package/Publish SQL tab.

Or if anyone knows a better way to create a custom schema comparison script automatically.

Any help would be appriciated. I need to develop this urgently.

Thanks

What I have tried:

.