sql-server-data-tools Questions
2
Solved
One of our build servers has just been updated to the latest "Microsoft SQL Server Update for database tooling" (version 12.0.60629.0) and is now incompatible with the version of SqlPackage.exe we ...
Burns asked 6/9, 2016 at 17:19
2
Solved
I am trying to convert some older VS2005 projects over to VS2015 Enterprise. When I open any with a report project (.rptproj), VS says the project is unsupported.
Unsupported
This version of Visua...
Margaret asked 12/4, 2016 at 19:11
1
Solved
With the release of SSDT 2016 (GA), I've loaded SQL Server 2016 GA Developer Edition, the new SSMS 2016 stand-alone build, and even Visual Studio 2015 Update 2 (Professional edition) and Visual Stu...
Coverture asked 3/6, 2016 at 22:40
3
Solved
We are trying to set up a SQL project, on a new machine with Windows 7, VS 2010 with SP1 & SSDT 2010 (installed SSDT 2010 from ISO image). But getting the below message when I open the sqlproj:...
Plossl asked 2/7, 2014 at 10:30
4
I need to be able to publish an SSDT project programmatically. I am looking at using Microsoft.Build to do so but can not find any documentation. It seems pretty simple to create the .dacpac, but h...
Renfroe asked 3/5, 2012 at 19:40
1
Solved
This call to DacServices.Deploy has been working great for SQL Server LocalDB 2014, but fails when SQL Server LocalDB 2016 is installed:
string dacConnectionString = $"Server=(localdb)\\mssqllocal...
Priedieu asked 4/7, 2016 at 12:42
0
I am using Visual studio 2013 with the SQL data tools (SSDT) with SQL project.
When I open the project then every time it will checking some background models and showing the message like this "Ve...
Proctoscope asked 2/7, 2016 at 11:29
1
Solved
SSDT (I suspect) creates a table called __RefactorLog in any database you point it towards.
If I've hit a release is there any harm in deleting this table as I don't see any benefit in including i...
Sealer asked 25/6, 2016 at 11:57
1
Solved
I have a SQL Server project in a solution. I've made some updates to the database directly in SQL Server Management Studio and I want to update the SQL Server project in Visual Studio to match the ...
Coronograph asked 21/6, 2016 at 19:25
0
I am working on source controlling a database using SQL Server Data-Tier Applications. I've created my SQL Server Database Project in Visual Studio and am now in the process of automating the deplo...
Dayak asked 23/6, 2016 at 14:44
3
Solved
I want to use SSIS /BIDS project in Visual Studio 2012.
I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL
Server 2012.
VS 2010 was installed first follow...
Degradable asked 4/1, 2013 at 18:41
1
The question is: is there a way to have a setting in the *.tt file so that the generated files are set to a specified Build Action?
The thing is I am generating SQL script using a template. I use ...
Chatav asked 31/3, 2016 at 12:3
1
I have a solution that needs to target both SQL Server 2014 and Microsoft Azure SQL database V12.
In my project settings, if I set the target platform to Azure, I cannot publish to a SQL Server - ...
Biform asked 25/5, 2016 at 19:13
2
Solved
For years we have used the following code to setup databases in a base class for our functional tests for our DAL, and this has worked extremely well for us.
/// <summary>
/// Initializes th...
Assumpsit asked 13/5, 2016 at 1:21
1
I need to intercept an SSDT build to modify the build script. I've followed the MSDN Deployment Plan Modifier tutorial, but when I attempt to build the database project, I get the following error:
...
Organography asked 29/12, 2015 at 23:2
3
Solved
I have created database project in Visual studio 2012 Version 11.0.60610.01 Update 3.
I am using this database project for comparing and publishing database on SQL Server 2008 R2 Version 10.50.400...
Binnings asked 26/6, 2014 at 6:19
4
Solved
I have a SSDT-project. When publishing a new version I want to publish/initialize some data in the database as well. Can that be done using SSDT?
Turbidimeter asked 16/4, 2013 at 5:20
2
Solved
I made .bacpac file from Azure portal and save it to Desktop. Then in Management Studio 2016 Candidate right clicking on Databases and choosing Import data tier application i am targeting my file t...
Cataclysmic asked 14/4, 2016 at 19:42
4
Solved
I applied the SQL Server Data Tools patch to Visual Studio 2012 (Premium) and created a SQL Server CLR user-defined function project in C#:
public partial class UserDefinedFunctions
{
[Microsoft....
Adularia asked 29/10, 2013 at 19:56
4
Solved
I've installed Visual Studio 2015, but the ssdt features are missing as you can see below
I checked the ssdt option at the setup, and the only thing i did was change the default installation di...
Cagliostro asked 2/8, 2015 at 23:28
3
I am trying to create a solution for a web application (that also contains the database as a database project) and then deploy it from TFS using web deploy for the application and DACPAC for the SQ...
Cenogenesis asked 6/1, 2016 at 8:52
1
We have SQLServer01.Publish.xml when I double click this file and publish, it publishes a database to sqlServer01.
I wanted to ask can we publish this profile from code somehow ?
Whereto asked 30/11, 2015 at 15:52
4
Solved
I got this error:
rsUnexpectedCompilerError: An unexpected error occurred while
compiling expressions. Native compiler return value: ‘-1073741511’
,when compiling rdlc's on a new box on Visu...
Dorise asked 17/11, 2015 at 20:42
2
Solved
Is it possible to deploy different sets of seed data for different publish profiles using visual studio Sql Server Data tools database project?
We know you can deploy seed data using a post deploy...
Heer asked 16/11, 2015 at 10:26
1
Solved
A previous iteration of a SQL Server Data Tools project in my Visual Studio solution utilized FileTables/FILESTREAM. The codebase has since been refactored to not use FileTables so I removed all fi...
Baty asked 11/11, 2015 at 19:21
© 2022 - 2024 — McMap. All rights reserved.