sql-server-data-tools Questions
2
I am running SQL Server 2012 and VS 2010 with SSDT (SQL Server Data Tools) installed. My dev DB uses stored procs, functions, CLR objects, etc. It has a snapshot of prod data of about 500GB.
I cre...
Imprecision asked 14/12, 2012 at 15:12
3
I have a SQL Server CLR trigger project that was created in VS2008. Opening the project in VS2012 does not present any problem, but on build of the solution, I get SQL71501 errors, with Trigger: [....
Effectually asked 31/7, 2012 at 5:5
2
Solved
Is there a method/ mechanism available to run a different set of post-deployment scripts in the SSDT-based database project in Visual Studio 2012/ 2013, based off of the build configuration? I woul...
Iridescent asked 27/8, 2014 at 15:31
1
We have a moderately-sized SSDT project (~100 tables) that's deployed to dozens of different database instances. As part of our build process we generate a .dacpac file and then when we're ready to...
Costard asked 30/3, 2014 at 15:58
4
Solved
Having recently upgraded to SSDT 2012 I seem to be missing the option to just generate a T-SQL script instead of deploying the database to a server somewhere.
To be more accurate the predecessor t...
Rivarivage asked 5/4, 2012 at 16:15
1
Solved
I'm trying to publish a database project, which also contains a partition function.
My destination databases have different (date) values which I do not wish to modify, although SSDT/SqlPackage alw...
Marven asked 2/4, 2014 at 0:27
4
Solved
I downloaded MS SQL Server 2014 Enterprise Edition from MSDN. I want to do a server backend in C# and MS SQL, but the problem is, whenever I want to do something with DB in Visual Studio 2013 Ultim...
Kesterson asked 22/6, 2014 at 13:30
1
Solved
I have started to prefer SSDT to SQL Management studio. But suddenly when I needed it I could not find SQL Server Object Explorer in view menu.
Not sure who took it away, I recently pushed updat...
Heft asked 14/6, 2014 at 16:30
1
Solved
We have always done our database design and development with VS2012 SSDT using the .sqlproj extension, and deployed to SQL Server using SQLPackage with a DACPAC... or alternatively setup a publish ...
Closegrained asked 22/5, 2014 at 8:57
3
In Visual Studio 2012, we have Schema Compare in SSDT's SQL Server Database Project (DbProject) project which helps
Compare source versus target
Update target to make it the same as source
Whe...
Daniels asked 19/12, 2013 at 4:31
1
Solved
I am using visual studio 2013 and trying to learn local database operations. I have created a database using VS and create tables. But I cannot rename table names. There is no such a option anywher...
Sig asked 22/3, 2014 at 12:35
1
Solved
We have a C# web project authored in Visual Studio 2013 which incorporates a Database Project, and I've set up a number of TeamCity build configurations to do Continuous Integration.
Team City is ...
Plucky asked 7/3, 2014 at 4:12
2
Solved
I'm trying to create a user with a login for a SSDT database project. The login already exists on the target server. With the following SQL:
CREATE USER [MyLogin]
FOR LOGIN [MyLogin]
WITH DEFAUL...
Michalmichalak asked 7/11, 2013 at 23:19
2
It looks like SSDT supports only suppressing warnings but not errors. I have many errors, all stating:
Error 4 SQL71561: View: [dbo].[x] has an unresolved reference to
object [DB1].[dbo].[y].[c...
Lobectomy asked 27/3, 2012 at 17:28
1
In Visual Studio 2012 I have two database connections configured in the Server Explorer. One is for a SQL Server 2008 R2 database, the other is for a SQL Server 2012 database. I've always been able...
Monoxide asked 21/7, 2013 at 9:15
1
Solved
After installing Visual Studio 2012 Ultimate on Windows 8, SSDT via SQL Server Object Explorer did not work. The solution was to install the latest version of VS2012 from the MSDN website.
All was...
Extort asked 25/11, 2013 at 18:9
1
Part of the SSDT functionality is the ability to fill in non-nullable columns with dummy values via a temporary, default constraint (termed "smart defaults").
Per trial and error, I have discovere...
Gretna asked 10/12, 2012 at 19:26
1
I just upgraded my existing SQL Server 2008 r2 .dbproj to a SQL Server 2012 .sqlproj (using SQL Server Data Tools).
Previously, I was able to define a SQLCMD variable in my project, and then defin...
Molly asked 5/7, 2012 at 14:56
1
Solved
I am learning Visual Studio 2012's "database project" system, using Visual Studio 2012 with Update 1, plus SSDT.
I am finding it very good at finding real problems in my database, especially progr...
Animosity asked 17/3, 2013 at 18:32
2
I have an utility which fills version numbers in AssemblyInfo.cs files. Now I need to implement a functionality to adjust version numbers for Visual Studio Data-Tier applications (DACPAC).
I see t...
Permanganate asked 4/1, 2013 at 11:20
1
Solved
I am new to SQL Server Database Tools and may be making incorrect assumptions about what the post deployment scripts are doing.. so correct me if I am wrong.
As far as I am aware the post deployme...
Rhea asked 23/7, 2013 at 22:50
1
Solved
I want the comparison below to not show a difference. According to MSDN
(see step 7), there should be a SQLCMD Variables function available which I cannot find. This documentation is for SQL 2010, ...
Compensatory asked 10/7, 2013 at 1:13
1
Solved
Error 431 SQL71561:
Computed Column: [dbo].[ViewAlertFrequency].[BeginDate] contains an unresolved
reference to an object.
Either the object does not exist or the reference is ambiguous because ...
Weapon asked 29/6, 2013 at 1:30
1
Solved
The following references are being automatically added to my (console application) project:
Microsoft.Data.Tools.Schema.Sql.UnitTesting.dll
Microsoft.Data.Tools.Components.dll
My boss can't open...
Alisa asked 21/5, 2013 at 12:37
2
Solved
Can I use the new SQL Server Data Tools that come with SQL Server 2012 to create SSIS packages for SQL Server 2008?
I work with both SQL Server 2008 and SQL Server 2012 and I am wondering if I can...
Joaquinajoash asked 4/5, 2012 at 14:44
© 2022 - 2024 — McMap. All rights reserved.