Stack Overflow
Stack Overflow

Questions tagged [dbproj]

dbproj refers to Microsoft Sql Database Projects cerca VS2010. The project files for this type ended in `.dbproj`

32 questions
2
votes
1 answer

Remove VS DB deployment script dependency on server name

When I deploy dbproj to SQL script and try to run it on another computer I get an error: The server name in the build script SOMENAME does not match the name of the target server ANOTHERNAME. Verify whether your database project settings are…
Dmitry Fedorkov
  • 4,301
  • 1
  • 21
  • 30
1
vote
4 answers

VS1010 Database Projects and reference data scripts

Just wondering the best way to handle the following.... I want to have a VS2010 database project to keep the schema of my database in the dev, integration test and production environments in sync. As part of the test and production environments I…
Remotec
  • 10,304
  • 25
  • 105
  • 147
1
vote
1 answer

VS2010 Partial Database Projects, will they help in my scenario?

Can I use partial Database Projects in the following scenario? I have numerous databases which are all inter-dependent on each other. Database2 executes SPs on Database1 and Database3 and Database3 executes SPs on Database2. For example: Database 1…
Ant Swift
  • 20,089
  • 10
  • 38
  • 55
1
vote
2 answers

CruiseControl.NET: Ignore DB projects in a build

After upgrading to VS2010 we have a few .dbproj files that are causing issues in our CI builds. They do nothing except just store SQL files anyway, so I'd like to just ignore them. I'm running CruiseControl.NET and building my solution with…
Wes P
  • 9,622
  • 14
  • 41
  • 48
1
vote
0 answers

In a Visual Studio 2010 Database Project, how do I make a specified user the owner of a Schema?

As the title says, I have a user defined in my DB project that needs to be setup so that it is the owner of a specific Schema. How do I define that in the DB project? I need to modify the creation of the Schema so that it looks like: CREATE SCHEMA…
Dugan
  • 908
  • 2
  • 13
  • 30
1
vote
0 answers

Database Test Configuration AllowConfigurationOverride database name

How can I get different build agents to run the unit tests against their own specific instance or database name? Are there any property overrides or variables available in .dbunittest.config files ? I have a TFS 2010 build server with the default 4…
gregn
  • 1,260
  • 1
  • 14
  • 25
0
votes
1 answer

Stop DB Project Launching by default when hit F5.

Using: MVC3, Vs2010, and a DbProject In a Solution I have an MVC3 project and a DB project. Whenever I hit f5 to startup the MVC project, the DBproject starts before. I dont want this behavior. I just want to launch the MVC project and not both…
user1040478
  • 97
  • 7
0
votes
1 answer

VS 2019 Db Project - Cant use ChangeTable

I'm having a bit of trouble using change tracking in a vs 2019 db project. I have referenced master in my db project and have ensured the function actually runs, However I cannot build my db project as I keep getting this build error. the reference…
BOT_Billy
  • 41
  • 4
0
votes
2 answers

Visual Studio error when trying to open dbproj files

I have Visual Studio 2008 Database Edition, and everything worked great until the first time I tried to load a .dbproj file. These database project files work for the other developers I work with, but when I try to open it, I just get an error…
Alain
  • 26,663
  • 20
  • 114
  • 184
0
votes
1 answer

STATISTICS_INCREMENTAL in CREATE TABLE

This syntax is legitimate as you can see there CREATE TABLE dbo.test1 ( ID int not null, SomeDate datetime2(7) not null, CONSTRAINT PK_test1 PRIMARY KEY CLUSTERED (ID, SomeDate) WITH (STATISTICS_INCREMENTAL = ON) ON PS(SomeDate) ) ON…
Alsin
  • 1,514
  • 1
  • 14
  • 18
0
votes
1 answer

VS2017 DBPROJ SQLCMD Variable Test for Literal Value

I want to conditionally run a post-deploy script. My script (currently) looks like this: declare @tier nvarchar(100) = $(tier) if( @tier = 'TEST' ) begin :r .\ConfigSeedData.TEST.sql end I have defined the variable in the project file,…
emery.noel
  • 1,073
  • 1
  • 9
  • 24
0
votes
1 answer

DBProject TFS 2015 Build ignores external references

We have a TFS 2015 build server running the new Agent in Agent Pool. Also we have a solution with three MS SQL database projects. One of these projects has references to another two. When I build this solution in Visual Studio 2015 on my PC, the…
Dennis Belevantsev
  • 3
  • 2
0
votes
1 answer

Publishing with .dbproj turns off transparent data encryption

I noticed in the Azure Dashboard that something was turning off Transparent Data Encryption (TDE) on my database. I had turned it on through the Azure Portal. Realized that something in my dbproj publish process included: SET ENCRYPTION OFF There…
viggity
  • 15,039
  • 7
  • 88
  • 96
0
votes
1 answer

VSDBCMD deployment for additions to third party databases

We have some custom objects (stored procedures etc) in an SQL Server 2005 database belonging to an ERP system. The custom objects are in different schemas to the ERP objects. We're using Database Edition .dbproj projects and vsdbcmd deployment for…
Sam
  • 4,694
  • 2
  • 36
  • 47
0
votes
1 answer

Visual Studio 2010 - cannot open database project (null reference)

I'm recently faced with problem that my VS2010 cannot open the database project. It's ends with: .dbproj : error : Object reference not set to an instance of an object. It happen with existing projects and new ones as well. I tried to…
xurc
  • 99
  • 2
  • 11
1
2
3