Sunday, June 24, 2007

How to run scripts from VSTS for DB Pro in Management studio?

Why output script from VSTS for Database pro failed to execute in Management Studio?

Database pro output scripts are valid t-sql syntax, but remember: Database pro uses SQLCMD to deploy databases.

How can you make it run?

In Management Studio you need to swap into SQLCMD mode.

  1. Tthrough the Query -> SQLCMD Mode menu.
  2. Click the red exclaimation icon in your toolbar.

No comments: