database-project Questions
3
Solved
We have a solution with three database projects. All three produced dacpacs are deployed sequentially but for some reason, one of these dacpacs does not run the post-deployment script.
We're using...
Berriman asked 7/6, 2013 at 10:12
3
I am using Schema Compare feature in Visual Studio 2017 to compare a database with database project (.sqlproj).
If I apply some changes to the project it also adds blank lines to some of the schema...
Pictorial asked 20/4, 2018 at 14:59
1
Solved
I'm trying to set SQLCmd variables based on configuration (Debug / Release, etc) but the Configuration dropdown is greyed out (see image below). For Dev environment, I want the SQLCmd variable to b...
Shastashastra asked 9/10, 2014 at 16:14
2
Solved
I'm setting up database projects for the first time and I'm trying to build/deploy using Azure DevOps. I'm using the MSBuild task hosted in Azure (windows-2019) for the build. I'm using a Command L...
Killarney asked 25/3, 2020 at 20:7
7
Solved
We are using Visual Studio and a database project to generate our database.
I just made a number of database changes (including adding a new table named Correspondence) imported those changes into...
Cochise asked 10/2, 2012 at 22:11
3
Solved
We have two database projects, x and x_audit. x has a reference to x_audit.
x_audit deploys fine, but when trying to deploy x we get the error:
The reference to external elements from the source ...
Casals asked 9/7, 2012 at 7:52
2
Solved
I've been running a schema compare in a database project in Visual Studio 2017, when I do this I get the following message in the Error List tab:
Unexpected exception caught during population of...
Zygapophysis asked 1/11, 2018 at 14:39
3
I am using Visual Studio 2012, with a SQL database project and running database analysis against this database and it is raising the following warning:
WITH CHECK | NOCHECK OPTION FOR EXISTING DATA...
Ardolino asked 28/1, 2013 at 8:36
5
Solved
In Visual Studio 2013, I have created a database project and imported an existing database. At first all was fine, and the project built and produced create scripts.
However, now Visual Studio see...
Pogrom asked 14/1, 2015 at 17:22
2
Although I can find (on the web) a lot of information about the PreDeploy and PostDeploy Build Action for SQL scripts in a Visual Studio 2012 Database project and I understand that None does not co...
Kinney asked 11/8, 2016 at 13:8
5
Solved
I'm looking at the Database Project in VS2010, the idea being that I want something I can use to keep track of the database schema (in source control) and the ability to generate "new install" scri...
Commissar asked 29/3, 2011 at 14:54
12
Solved
I have created database project using VS 2012. Once the schema comparison is done, the update target button should be enabled to sync with target, but it's not getting enabled. How can I fix this?
...
Declass asked 19/7, 2013 at 9:29
2
I've built a database in SQL Server 2008 R2 and am using Visual Studio 2010 Ultimate to create a database project for it.
I've created both a SQL Server project and Database project to represent m...
Dispassionate asked 7/5, 2013 at 20:12
5
Solved
Disclaimer: There is a similar question on SO that appears to be referring to an older version of SSDT. The selected answer references settings files that are not in my project. I believe I have th...
Archaism asked 12/7, 2013 at 16:58
2
I have a SQL Server database project (VS2017) and in project properties, the SQLCMD Variables tab looks like this:
Question: I can create a SQLCMD variable and set a Default Value and a Local Va...
Michaels asked 27/7, 2018 at 9:51
4
Solved
I have setup my .NET project in TFS Build. It builds fine locally, but I am getting this build error on the server:
The imported project "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v1...
Hose asked 3/11, 2012 at 1:27
3
Solved
I'm getting the following warning in my Visual Studio 2013 project:
SQL71502 - Procedure has an unresolved reference to object
Peanut asked 28/4, 2015 at 3:20
16
Solved
I've got a database project as part of my solution in Visual Studio 2013. Been working perfectly for the last 3 weeks and now suddenly today it won't build and so I cannot publish any changes. I'm ...
Sublunary asked 26/8, 2014 at 12:30
2
Solved
I am using Visual Studio 2008 Database Project GDR2 to manage multiple databases and I am getting a number of errors related to synonyms.
Project-A has a reference to Project-B because Project-A ...
Escalator asked 20/7, 2010 at 21:8
1
Solved
SQL Server database project gives warning 'Unresolved reference to object sp_executesql' when using sp_executesql inside a stored procedure.
Demetrius asked 20/10, 2020 at 0:37
2
Solved
I have created a database project in VS2012. I added database structure. It works fine to publish and compare database.
Now on publish I want to automatically load several tables with default data...
Procaine asked 28/5, 2013 at 8:45
3
Solved
It's been a while sinse I used database projects and I'm tearing my hair out trying to figure out where to set the database name for this project.
I've tried in the SQLCMD variables section, but i...
Earthshaker asked 17/12, 2015 at 9:14
2
Solved
I have a new .net Core 2.0 Web API project (In Visual Studio 2017 Version 15.3.5) where I can´t build the solution if I add a new database project.
error MSB4019: The imported project "C:\Progra...
Stepchild asked 26/9, 2017 at 16:36
4
Solved
I would like to create a delta script from the database and my database project. The database as source and database project as target. The Update button works fine without any errors and my Error ...
Bronchi asked 23/10, 2017 at 11:52
2
Solved
I recently had a PC failure and reinstalled the Windows OS and all my development software. After re-installation, my Visual Studio 2012 Database Projects seems to work differently and I cannot fig...
Rabinowitz asked 18/1, 2014 at 19:42
1 Next >
© 2022 - 2024 — McMap. All rights reserved.