Click here to Skip to main content
14,454,243 members
Rate this:
Please Sign up or sign in to vote.
Hi
I am working on a project that uses database(sql server 2008) to store some data. During the development the schema of the database will change a few times. When the update for the software will be installed on a machine I need to examine the schema of the database that was used before the update and the schema of the database that will be used after the update. Is there any tool available that will inspect the differences of the schemas and created the update script which can than be used to modify the existing schema to the new schema. I would need a tool that can be run programmaticaly(using a commmand line or something similar). Does anybody knows of a good tool that can be used to achive this, or does anybody know a different way of achiving this? Any advice will be appreciated.

Uros
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You should be using visual studio database (VSDB) projects for this. Please check the link http://msdn.microsoft.com/en-us/library/xee70aty.aspx[^] for more info. VSDB allows command line deployment using VSDBCMD utility. It is fairly easy to migrate to VSDB based development and deployments.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100