Geeks With Blogs
Catherine Russell Architect, President of "Women In Information Technology" Group

If you plan to compare a database project to a target database on a recurring basis, you can add the schema comparison to your database project. You can then re-compare the schemas by re-opening that comparison. By saving a schema comparison, you save connection information, session-specific options, and values for SQLCMD variables. Results are not saved, and they will be re-generated when you open the .scmp file for the saved schema comparison.

To set this feature, go to "How to: Compare Database Schemas"
http://msdn.microsoft.com/en-us/library/aa833435.aspx

I set this feature up and when I run the script, I was getting an error in VS2010.  "Text lines should not be null."

After I installed DACProjectSystemSetup_enu.msi from the VS2010 disc found under \WCU\DAC the script worked.

 

Posted on Monday, September 27, 2010 1:48 PM ASP.NET | Back to top


Comments on this post: Schema Compare Options are for comparison between Project and Database

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © CatherineRussell | Powered by: GeeksWithBlogs.net