开发者

SQL Server 2008 Database Project deployment issue

开发者 https://www.devze.com 2023-01-05 22:07 出处:网络
I\'m having issue with how to to deploy (a SQL2008 project) to multiple dbs. I\'m using VS2010 + SQL Server 2008 Database project, it imports the \"DevDB\", works all fine.

I'm having issue with how to to deploy (a SQL2008 project) to multiple dbs.

I'm using VS2010 + SQL Server 2008 Database project, it imports the "DevDB", works all fine.

Now I want to deploy it to a differen开发者_运维技巧t DB "TestDB", both DBs are on the same SQL server.

It's keep complained about ".mdf and .log" conflicts.

In SQL 2005 db project, I can just created 2 db connections for deployment, but how to I achieve that in 2008 database project?


If you import your database from the same server you're deploying on, you'll need to edit the yourDB.sqlfile.sql and yourDB_log.sqlfile.sql (in Schema Objects/Databaes Level Objects/Files) and change the references to your database name for all references of the old name, otherwise there is a clash.

See http://continuouslyintegrating.blogspot.com/2009/12/database-already-exists-error-visual.html

0

精彩评论

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

关注公众号