Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [visual-studio-2013]

22 questions
34
votes
2 answers

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

I have worked a couple of times with post deployment scripts and always, intuitively used the build action "PostDeploy", because that is what it is. Now for the first time I try to follow the built-in instruction from the script's template to use…
Magier
  • 4,827
  • 8
  • 48
  • 91
9
votes
1 answer

Reference assembly in sqlproj not being deployed to server

I have a Visual Studio 2013 Database Project which takes a modified version of fastJSON as a reference. I selected Generate DDL in the reference properties as shown in this screenshot: And in the .sqlproj msbuild file:
Justin Dearing
  • 2,717
  • 6
  • 36
  • 52
5
votes
4 answers

Script component source won't load when click "Edit Script..."

I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but no editor window loads. It's just an empty window…
Chris Pratt
  • 311
  • 2
  • 3
  • 12
3
votes
3 answers

Visual Studio database project and Enity Framework code-first

At work we are developing our latest module in C# Entity framework code-first approach. I have been given the role of developing databases from the DBContexts from within the project/s. I generated the tables/entities from the DBContext and created…
Guygar
  • 131
  • 1
  • 2
3
votes
2 answers

SSIS: script task on Visual studio 2013 can not open since Visual Studio 2015 was installed

Until the installation of Visual studio 2015, it was always opening Visual studio 2012. Attached the only error he throws, It seems he was trying to open Visual Studio 2015.
Refael
  • 239
  • 4
  • 7
3
votes
1 answer

How to manage stored procedure dependencies in SSDT?

I have multiple stored procedures, some that depend upon others. When publishing my database, I receive an error when creating some stored procedures due to dependency issues. SSDT seems to be creating the stored procedures in alphabetical order,…
mw007
  • 133
  • 3
2
votes
1 answer

Prevent Subscription to report from running on a holiday

I have a SQL Server that I am using for building and distributing reports. I have built all the packages for importing data as needed as SSIS packages. These reports only need to be run after the data has been imported. I have built my SSIS…
JamesTheDev
  • 155
  • 7
2
votes
1 answer

How To Merge Database Projects on Visual Studio 2013

Can I have multiple database projects to the same SQL Server database? Like, one main project referencing multiple subprojects. I have an application with multiple modules and each module has its own database structure living in a schema. I want to…
sergiogarciadev
  • 123
  • 4
2
votes
1 answer

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a number of SQL statements are not available in SQL…
Cristiano Ghersi
  • 221
  • 2
  • 4
2
votes
1 answer

Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)

I have a SQLCLR stored procedure with the following signature in Visual Studio 2013: [SqlFunction(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read)] public static SqlString ExecSql2Json(SqlString sql) Or alternatively…
Justin Dearing
  • 2,717
  • 6
  • 36
  • 52
2
votes
1 answer

How to Publish Checked-In changes only in Team Foundation Server 2013 to SQL Server?

I would like to ask you how to publish checked-in changes only in Team Foundation Server 2013 to SQL Server? It's a new installation of TFS 2013 - installed by me. Currently when I create new object like table as a part of the project and don't do…
Tomasz Wieczorkowski
  • 362
  • 4
  • 17
2
votes
2 answers

Data Flow Transform Not Automatically Mapping Columns

I'm in the midst of creating a set of SSIS 2014 packages (using Visual Studio 2013) importing data from 50 tables. Since most of the tables are being filtered on the same column and I'm importing all columns into my staging area, I opted for a…
MattyZDBA
  • 1,955
  • 3
  • 20
  • 32
2
votes
1 answer

Migrating Oracle 9i database to MySql database on a different Windows Server

I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have successfully imported the files (.aspx) to Microsoft…
BioDeveloper
  • 121
  • 3
2
votes
0 answers

SSDT sqlpackage.exe CreateNewDatabase Parameter Not Respected

Originally asked this on SO but that question seems to be populated only by tumbleweed so wondered if this might be a better forum for it. I have a VS2103 solution which includes a database project for which we have a number of publish profiles. One…
Steve Pettifer
  • 441
  • 4
  • 10
1
vote
0 answers

TDE state is changed after DB deployment

I have database projects in Visual Studio 2013 from which I deploying databases to SQL Server. Also I am using Transparent Data Encryption for these databases and it is in state 3 which means TDE is ON. Issue becoming when I deploy databases. After…
kat1330
  • 111
  • 2
1
2