Vs2008 database edition -database depolyment

Question

  Can I take Deployment Script created during deployment  to run it on the server to create a new DB that has all schema changes? It seems it has syntax errors at the very beginning.

Answer 1

If you are using VS2008 DBPro with out the GDR R2 update installed, then the Sql script created at build time should not be used against any other database than the one that it was created for.

Now, if you are using GDR R2, then at build time you get a .dbschema file instead of a .sql file. This is a model representing the database schema. You can then take that .dbschema file and deploy it against any database you want, and it will dynamically generate the deployment script needed to make the target database schema like the one in the dbschema file.

Christian.

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

GDR R2 can only be installed with SQLServer2008, right? Thank you.

Answer 3

Do you mean Visual Studio 2008? Because that is correct, GDR R2 can only be installed on Visual Studio 2008.

If you mean, "Can GDR R2 only deploy to Sql Server 2008?" That is not true. The GDR R2 gan target SQL 2000, SQL 2005, and SQl 2008.

Hope this helps.

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

I found the infomation here   at  http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en  , it says:

Brief Description

Microsoft® Visual Studio Team System 2008 Database Edition GDR
Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 implements support for SQL Server 2008.



So I thought it was only for SQLServer2008, is it not right? Thank you.

Answer 5

The script generated must be run in sqlcmd mode. In management studio select query form the top menu and then select sqlcmd mode

Anthony

Answer 6

gdr r2 can deploy to sql 2008, sql 2005 and sql 2000 instances. support for sql 2008 was added in gdr r2 - previous versions could only deploy to sql 2005 and sql 2000 instances

Answer 7

I have  Visual Studio Team System 2008 Database Edition GDR , Mirosoft SQL Server 2005 , VS Team System  2008 Development Edition  and  Vs 2008 Professional Edition installed, when I install GDR R2, it errors out :

Visual Studio Team System 2008 Database Edition GDR does not apply, or is blocked by another condition on your system. Please click the link below for more details.
and it takes me the following link by clicking more Information

http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en

which is GDR R2 download page.

What did I miss ?

Answer 8

I have GDR R2 update installed,  .dbschema file is generated at build time. How do I run  .dbschema file on the target server to get deployed ?

Thank you !

 

 

 

Answer 9

You have to options, you can use msbuild to do a deploy which you can deploy directly to the database server or to a file that will generate a .sql file that you can run in SQLCMD mode.  The other option is to use vsdbcmd.exe to deploy directly to a server of a file.  My recommendation is to do the msbuild to deploy to a file.  VSDBCMD.exe has bugs in it that prevents me from using it.

Answer 10

JAdams2006, what is the bug that prevents you from using VSDBCMD?

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 11

Here it is: 

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/bc88ed63-930c-4337-a1b2-563a29a06753/

It is mostly dependency issues that VSDBCMD has.  Wish I could use it as the concept of it is great.