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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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, ...

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...

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.