开发者

Visual Studio 2010 SQL Database Project Command-Line Schema Compare

开发者 https://www.devze.com 2023-04-10 17:36 出处:网络
I use SQL 2008 Database Project to keep track of all my database changes and easilly update databases by running schema compares on them.

I use SQL 2008 Database Project to keep track of all my database changes and easilly update databases by running schema compares on them.

A bad thing is that I need to have VS2010 on the machine I want to perform the schema compare.

Currently I've been able to open a door on the remote servers and connect to them, executing the schema compr开发者_如何转开发are on my machine but it would be great if I could execute everything right on the destination server.

Is there a way to perform a schema compare using nothing but the generated DB Project schemas?


I'm not sure why is it a bad thing that you have SQL2008 databases and work with VS2010. I do it every day. But if you just want to compare two DB schemas (meaning .dbschema files).here is an article on how to do it: http://msdn.microsoft.com/en-us/library/aa833435.aspx#comparewithvsdbcmd

0

精彩评论

暂无评论...
验证码 换一张
取 消