We have a database project in Visual Studio 2008 that has been working great. Out of the blue, however, deployment stopped working. This is the error we get: EZTrac.Database.dbschema : Deploy error TSD01234: Microsoft.Data.Schema.SchemaModel.ModelException: At least one identifier expected. We've searched everywhere tryin...
I have imported an existing SQL Server 2008 database to a Visual Studio 2008 database project, to version control database objects and perform database code migration. This works fine and I can build and deploy to dev, test, staging, live etc. Now I want to add a new stored procedure (with a grant statement) to the existing database pro...
On a per-object basis, SQL Server Management Studio has the option to script the object to clipboard, file, etc. Is there a way (at the database level) to do a "1-click" export of ddl AND data to a text file? Ideally I'd like to select a database and create a big text file containing the ddl for all objects plus the data in all tables....
What is Visual Studio 2008 Database Edition -- is it different from Visual Studio 2008 Professional Edition? ...
Suddenly I can't process a SSAS project anymore. The error I get is 'x.partitions' is not valid and cannot be opened. Check the 'x.partitions' file Last thing I remember was a checkin of the project into TFS. A good idea to fix this would be very much appreciated. The Cube that is causing the problem is a cube with 2 linked cubes in i...
I have a new Visual Studio 2008 Database Project (Data Dude). It was generated by pointing at our existing database. I have now made a few changes (new columns, tables, indexes, etc) and I am trying to generate the deployment (diff) script for deployment. I have a Schema Comparison setup to do the comparison and generate the diff scri...