database-project Questions
2
Solved
Based on this question, I've created a function and added it to my database. Now I want to use that function as a calculated column:
-- Based on https://mcmap.net/q/118137/-how-to-strip-all-non-al...
Deanery asked 29/8, 2019 at 13:49
3
From the Schema Compare Options, I deselected all Object Types:
It still shows me differences in Schema objects:
I scrolled through the big list of General options, and none of them appeared ...
Burhans asked 17/7, 2013 at 20:32
2
Solved
It all started with the VS2017 runner type within TC. It was failing without any errors or hints (except the (default targets) -- FAILED. message on the solution level). I narrowed it down to the ....
Bucaramanga asked 26/7, 2017 at 9:37
5
Does anyone know the best way to drop an existing column from the database when there are rows of data in the datatable.
What I tried doesn't seem to want to work. I included a pre deployment scri...
Stinger asked 3/9, 2014 at 20:33
0
I'm creating a visual studio database project.
In one of the script, I want to achieve something like
CREATE USER [$(DatabaseName)\UserX]
WITHOUT LOGIN
WITH DEFAULT_SCHEMA = dbo
Which popups...
Coauthor asked 9/5, 2018 at 4:7
4
Solved
I created a new SQL Server Database Project in VS2013 (Update 3) and attempted to build but it fails. The only build output I receive follows:
------ Build started: Project: Database1, Configurati...
Ordinance asked 10/9, 2014 at 20:25
2
Solved
I've created a SQL Server database project in Visual Studio 2013 and imported a DACPAC taken from a production database. When I tried to build the project I get hundreds of SQL71501 and SQL71561 er...
Azote asked 8/9, 2014 at 2:36
0
Problem
I'm trying to automate SQL deployment including User and Roles. It works when I create the user in Sql Management Studio, but when I deploy dacpack I get SqlException: Login Failed for use...
Older asked 27/10, 2017 at 9:55
1
Solved
When I log in to azure portal select my SQL Database -> Tools -> QueryEditor and enter:
ALTER USER MyUser WITH Password = '**********'
I get the error:
Failed to execute query. Error: The par...
Farman asked 16/10, 2017 at 8:17
2
Solved
I am developping an SQL Server Database Project in Visual Studio which is in fact a User Defined Function. In this project, I included Json.NET as a reference (using NuGet).
I managed to publish (...
Hirschfeld asked 15/3, 2016 at 17:40
1
Solved
The solution builds successfully on my machine but not on the build server. There are the project's solution
Projects within solution
This is the MSBuild output
[13:42:17][Step 2/5] MSBuild out...
Gymkhana asked 13/6, 2017 at 21:2
1
Solved
I added a new SQL Server database project to my solution in VS2015. I added all of my tables to this project.
I am now trying to figure out how to add foreign keys to the project through the UI pr...
Nikolai asked 25/3, 2016 at 11:51
2
Solved
When I try to publish a database project, while Creating Publish Preview..., I get this error: Could not find file 'C:...[DatabaseProjName]\sql\debug[DatabaseProjName].dacpac'.
How do I get this fi...
Nonna asked 26/6, 2014 at 15:29
2
Solved
Assuming we have a database project called MyDatabase then a file called MyDatabase.jfm appears in the root of the project directory.
It is exclusively locked while the project is open in Visual ...
Radford asked 8/6, 2016 at 13:52
2
Solved
My database projects in Visual Studio have recently starting throwing these unresolved reference errors every time any create table file in the project is touched.
SQL71501: Column: ___ has an unr...
Aaron asked 14/1, 2016 at 10:37
1
I have a question that is very similar to an older question of mine Using variable in sql postdeployment build script?
But now I don´t want to do an if/else and have the sql code in my published s...
Longs asked 16/3, 2017 at 23:10
0
I am failing to deploy Database project using command line parameters with msbuild. I would like to:
use publish xml profile
define connection string as command line parameter
but this seems to...
Guinn asked 11/3, 2017 at 23:36
5
Solved
When I create a Visual Studio database project for SQL 2012 and synchronise it with an existing database (using Compare Schema), I also synchronise a SQL server login. Visual Studio generates the f...
Nasion asked 4/6, 2012 at 16:28
2
It looks like Visual Studio Database Project does not parse SQLCMD-variables doing a schema-comparison.
All my synonyms looks like
CREATE SYNONYM [dbo].[addressesExtDB] FOR [$(ExtDB)].[dbo].[add...
Autotruck asked 14/11, 2012 at 9:6
6
Solved
I'm just in the middle of migrating my solutions from Visual Studio 2010 to Visual Studio 2013.
I have this (maybe) silly problem with database comparisons options. I would like to exclude certain...
Donelladonelle asked 3/11, 2013 at 22:27
2
I have a SQL Server 2008 DB Project, and want to execute multiple scripts, in order, on post deploy.
I've added a PostDeploy.Sql script to a scripts folder, and marked that as PostDeploy, and that...
Overstudy asked 17/4, 2014 at 10:48
1
Solved
I was unable to google this.
We have an existing database project (sql server).
Some new files (scripts) were added.
We have an existing server / database where some new scripts need to be run i...
Dodson asked 2/2, 2016 at 23:18
4
Solved
Just wondering if anyone knows how to set a saved publish profile as the default i.e. profile that's automatically loaded when I select publish. I love the new profile approach but I'm a bit over h...
Chaworth asked 22/3, 2013 at 9:52
1
I would like to be able to do schema compare between my Visual Studio 2012 Database Project and a Development or Production database, however there are a number of tables which are dynamically crea...
Giffer asked 11/6, 2014 at 16:26
1
Solved
GIT in Visual Studio is reporting the .dbmdl file is in use by another process.
When it does this, all the VS change tracking stops - no files show as changed.
Remove my DB project from the solut...
Triadelphous asked 18/12, 2015 at 14:28
© 2022 - 2024 — McMap. All rights reserved.