sql-server-data-tools Questions
1
Solved
My company uses a Visual Studio database project for deploying updates to our DB. As far as I can tell, it provides functionality for comparing the state of the project schema and a target DB, and ...
Tinkle asked 20/5, 2015 at 10:19
5
Solved
I'm getting this error while importing bacpac file from windows azure
TITLE: Microsoft SQL Server Management Studio
------------------------------
Count not load schema model from package. (Micro...
Toting asked 12/8, 2014 at 3:5
3
Solved
While converting database project to SSDT and upgrading to SQL Server 2012 I need deployment script to work for both SQL Server 2008 and 2012.
I am using sqlpackage.exe /Action:Publish to deploy t...
Graber asked 23/5, 2012 at 17:40
4
Solved
After updating to a recent service pack my Database project no longer builds.
I get the following error:
Error 1 04018: The "SqlBuildTask" task failed unexpectedly.
System.MethodAccessExceptio...
Countryman asked 17/9, 2014 at 19:43
1
The SQL Server Data Tools team blog mentions that it is now possible to use MsBuild to perform a schema comparison of two DacPacs or databases. However, they do not mention exactly how to pass in t...
Piccaninny asked 21/9, 2015 at 12:24
2
Solved
I know that I can define default values for CLR procedures when creating the procedure in the database, like this:
CREATE PROCEDURE [dbo].[ShredXml] (
@InputXml [xml],
@AttributeElementHandling...
Donnetta asked 21/6, 2011 at 6:4
1
I am using SSDT (and sqlproj) for our MSSQL projects. We have a few variables we need to set when publishing to each environment.
This works great on most of our environments where we assign value...
Ribbon asked 20/4, 2015 at 10:50
3
Solved
I have a database project in a solution which will not deploy from Visual Studio 2013. It fails with an error message "Unable to connect to target server".
The same project, when opened in Visual...
Hydrolyse asked 6/4, 2014 at 7:43
1
Solved
I have a project in ssdt and tfs. When I perform a schema compare, I get differences which include objects in which the only difference is a GRANT in the source which does not exist in the imported...
Propitious asked 13/7, 2015 at 16:26
3
Solved
I have a Visual Studio 2012 project that reports an error from msbuild when trying to publish the database from the command line:
Microsoft.Data.Tools.Schema.SqlTasks.targets(390,5): Build error...
Terryn asked 22/10, 2013 at 9:40
2
Today I maintain project that has really messy DB that need a lot of refactor and publish on clients machines.
I know that I could add a SQL Server Database project that contains just scripts of t...
Tuft asked 13/5, 2015 at 7:26
1
Solved
Running into a weird issue. Assuming there are two database projects in one empty solution, Bart and Homer. Bart has been added as a Database Reference to Homer.
Bart project defines a function:
...
Gainly asked 15/5, 2015 at 22:37
3
Solved
I run Visual Studio 2012 and I'm new to SSIS. I attempted to install SSDT-BI (June 2013 version) in order to research SSIS, but I was unable to complete the install with my default instance because...
Gracielagracile asked 26/8, 2013 at 23:33
2
I'm using SSDT for Visual Studio 2012 here and using its command-line tool SQLPackage.exe to publish a .dacpac file.
I want to publish that to an SQL Server database project. I'm trying to use par...
Natator asked 11/12, 2013 at 7:55
3
Solved
How to disable generating dll in VS2013 Database Project?
I don't use SQLCLR at all.
Rexfourd asked 16/3, 2014 at 15:41
1
Solved
I'm playing with a SQL Server database project with Visual Studio 2013 on Windows 2012 R2. Below is my code and you can download the whole project source code from my shared dropbox link at https:/...
Forewing asked 17/3, 2015 at 7:46
1
I am searching for days now on several forums, blogs, MSDN etc. but I was not able to find any guidance on this topic so far. I will try to explain this post in a more detailed manner because I thi...
Senter asked 2/6, 2013 at 16:38
2
Solved
I've imported a database into a database project and straight from the bat I'm getting 200+ errors about unresolved references. Now i've read several posts and sites like this one (http://blogs.msd...
Onder asked 3/10, 2013 at 8:10
4
Solved
I have a clean install of windows 7 with Visual Studio 2010 Premium inc. SP 1. I also just installed the developer edition of SQL Server 2012 .
I now should be able to convert the Visual Studio 20...
Chalmer asked 19/4, 2012 at 21:1
5
Solved
In SQL Server Data Tools, I would like to suppress some, but not all, occurrences of SQL71502 ("--- has an unresolved reference to object ---"). I know I can suppress through Project Properties, Bu...
Quelpart asked 31/5, 2012 at 0:27
1
Solved
The other day I have installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: Replacement for BIDS) and started using reporting features in VS2013.
Successful...
Davide asked 19/9, 2014 at 1:30
1
Solved
Using Visual Studio 2013
I have a set of 8 SSDT projects that can all be deployed to several distinct environments. The advanced publish settings for each project, however, are meant to be identic...
Partlet asked 13/1, 2015 at 13:44
3
I have created a new "Database" project in Visual Studio 2013. I have set the Target platform to "Windows Azure SQL Database". The project is nearly empty, with the exception of one .sql file to cr...
Busboy asked 27/9, 2014 at 1:39
2
Solved
In SQL Server data Tools you have the deployment option "Block incremental deployment if data loss might occur", which I'd wager is a best practice to keep checked.
Lets say we have a table foo, a...
Tollefson asked 12/8, 2013 at 9:29
1
I have a script that automates the creation of a database on a CI server, however, the output of SqlPackage.exe is very noisy. According to the documentation, there is a /Quiet:True flag to prevent...
Accountant asked 17/10, 2014 at 15:26
© 2022 - 2024 — McMap. All rights reserved.