How do you resolve Linked server references in SQL Database project in VS?
In a Visual Studio SQL Server Database project, how can you resolve the errors associated with linked server references within the project? ...
database-project
"Show All Files" option missing in VS Database Project
The VS Database Project does not seem to have the "Show All Files" option in the Solution Explorer. Does anyone know of a way to turn the option on in VS? The "Show All Files" option on the solution explorer actually does two things. With the option selected, VS shows "hidden/nested" files within the project AND it shows files within ...
Where is the handy designer for setting Permissions and schema diagram designer in a SQL2005 Database Project in VSTS2008 Database Edition GDR RTM?
I have just installed the GDR RTM version of Visual Studio Team System Database Edition GDR RTM. It all seems to work wonderfully, but I seem to have to edit XML (Database.sqlpermissions) for specify SQL Permissions. Am I missing something? For that matter where is the schema diagram tool? I understand GDR exposes alot for extending ...
Anyone using "database projects" in Visual Studio?
I've recently given it a try (SQL 2008 version) and I find them quite okay. Well, the only problem is that the wizard is not intelligent enough to update database structure without first erasing all data. Is this why these projects are not used in practice? Actually never seen anyone using them or ever mentioning them at all. Also nothi...
How to programmatically navigate the Schema View in Visual Studio 2008?
I'm planning to develop an Add-in for Visual Studio 2008 that will allow me to programmatically create basic procedures for tables in a Database Project. However I'm stuck in the very early stage because I can't find a way to programmatically navigate the schema view of the Database Project. Does anyonw know how do I do it? ...
Do I need the .dat file when I place a visual studio database project under version-control
I have a visual studio 2008 database project that is under version control (git). I am getting conflicts in the project_name.dat when I try to merge my branches. So my questions ares: What is the project_name.dat file? Do I need it? That is can I leave it out of my version control ...
Executing scripts from a database project in visual studio
I am trying to add some stored procedure to a build process in visual studio (using MSBuild). I have a database project (*.dbp) added to my solution, however unlike some of the other database projects available in VS i cannot build or run it. ( I believe this is the project file i want as I am using SQL2000) How can i get the SQL scr...
Post build on database project
In Visual Studio 2008, I have this database project to manage my SQL Server 2008 database. This has a prebuild and postbuild SQL Script that contains an example like this: :r .\myfile.sql What does this mean? ...
Duplicate Schema
I am creating and maintaining my SQL Server 2008 warehouse database using a Visual Studio 2008 project. When I try to deploy the project, I get an error as below Creating DataWarehouseReports... Company.HigherEducation.DataWarehouse.dbschema(0,0)Error TSD01268: .Net SqlClient Data Provider: Msg 2714, Level 16, State 6, Line 2 There is ...
Pre-Deployment in Database project
Visual Studio 2008 Database project for SQL Server 2008 The project has placeholders for Pre-Deployment and Post-Deployment SQL scripts. They work - well, most of the time anyways. The project has an option to Always-Recreate-Database: drop the existing database and create a fresh hot-from-the-oven database every time. When I deploy m...
Syncing permissions between a Database project and a database using Visual studio
I have a database project in visual studio (2008) that I am using to keep my database structure in a version control system (Git). I use the data schema compare tool in VS to maintain this database project. The issue that I'm encountering is that I keep losing my permissions for new objects. So how do I: Capture these permissions u...
Timestamps during MS Build
I have a single solution with multiple database projects and an SSIS projects. The entire build and deploy portion takes a few minutes especially because we deploy unit test data along with the build. Does Visual Studio 2008 allow me to display timestamps the output window of the build so I can keep track of things? I know I can execut...
database project takes a long time to open
Whenever I open my SLN that has multiple database projects under it, it takes a very long time (10 to 15 mintues) to open. The messages I get are: Analyzing database schema. Your database projects will be ready after 23000 operations are completed. Analyzing database schema. Your database projects will be ready after 45000 operations ar...
Unable to Load Database project in VS2008
I have Database project which I'm unable to load in VS2008 and I have SQL Server 2008 Express edition installed on my machine.. I get following error message, when I try to load Database projects require a connection to a local instance of Microsoft SQL Server 2005 for design-time validation. To perform this operation, you m...
Visual Studio 2008 Database project Deployment Baseline
Hi all, I have a question about creating a deployment script using a database project in Visual studio 2008. In a more traditional project we would create a deployment script that would create the DB and the initial objects for the first deployment. This would become the baseline. Any additional objects would be scripted as ALTER sta...
Using MS Team System 2008 Database Edition
Hi, guys! I'm wanting to start source controlling our DBs. I've read a lot of questions here and have found that MS Team System 2008 with Database Edition is what I need. So we get it and we are kind of lost really. We would like in first place, compare the different DBs we have (DEV, STA and PROD) because we had never done any source ...
How to force VS2008 to "Generate Create Script to Project" to multiple files when multiple stored procedures are selected?
I'm using Visual Studio 2008 Developer Edition and I've created a Database Project and want to generate CREATE scripts from my database and save them in my database project. It works just fine when I select a single stored procedure in the Database and click "Generate Create Script to Project". The problem is that when I select MULTIPLE...
Visual Studio For Database Professionals 2008
Anyone know any a few good references for getting familiar with the SQL Server 2008 Database projects? I am getting a bit overwhelmed and would love to find a walk through for putting this project type to good use. Thanks in advance. ...
Nontrivial incremental change deployment with Visual Studio database projects
Let's assume that I'm doing some sort of nontrivial change to my database, which requires "custom" work to upgrade from version A to B. For example, converting user ID columns from UUID data type to the Windows domain username. How can I make this automatically deployable? That is, I want to allow developers to right-click the project, ...
SQL Database Project in Visual Studio
Hi, I have a database ready which I am maintaining manually, I would like to now use that database to create an SQL project. I am creating also but not able to import the existing Tables, Views, Stored Procedures or any other object. Is there any way to do it. If yes please let me know. Thanks, Piyush ...