Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [deployment]

85 questions
55
votes
1 answer

Best practices for schema changes and data migrations to a live database without downtime?

How do you make schema changes to a live database without downtime? For instance, lets say I have a PostgreSQL database with a table including various user data like email addresses etc, all associated with specific users. If I wanted to move the…
Dan Leary
  • 653
  • 1
  • 6
  • 5
31
votes
1 answer

Designing a platform: one database or multiple databases?

We are building a web platform that incorporates multiple services, each with its own underlying data. These services are being built independently following the principles of Service-Oriented Architecture, but they transact against potentially…
Nick Chammas
  • 14,170
  • 17
  • 73
  • 119
27
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,585
  • 6
  • 37
  • 75
12
votes
2 answers

MongoDB: co-locate the mongos process on application servers

I would like to ask a question about a best practice described in this document: http://info.mongodb.com/rs/mongodb/images/MongoDB-Performance-Best-Practices.pdf Use multiple query routers. Use multiple mongos processes spread across multiple…
tenshi
  • 173
  • 1
  • 9
12
votes
3 answers

Excluding a specific table from a SSDT deploy

I have an existing database with everything in schema dbo. I have an SSDT project with objects I am adding to it with schema foo I have a table that looks like this in the project: CREATE table foo.a ( id INT NOT NULL CONSTRAINT…
Justin Dearing
  • 2,627
  • 4
  • 31
  • 46
9
votes
3 answers

SSDT Drop and Recreate Tables when nothing has changed

We have a Visual Studio Database Project consisting of about 129 Tables. It is the primary database for our Internal Web Based CRM/Call Centre product, which is still under active development. We use the SSDT Publish from within VS to deploy to…
OJay
  • 321
  • 2
  • 10
9
votes
1 answer

How to prevent SSDT publishing from dropping columns

I want to create a publishing profile that DOES a complete schema comparison and publishing BUT does not drop any tables or any columns that have been removed between the old and new version. I am aware of the BLOCK possible data loss option in the…
Magier
  • 4,585
  • 6
  • 37
  • 75
8
votes
2 answers

DACPAC and database drift: db users are always detected as drift even when nothing has changed

When I include a login and user in my SSDT DB project and try to deploy a DACPAC using the "Block publish when database has drifted from registered version" option, it always detects drift for the database user even when nothing has changed. For…
Matt
  • 375
  • 1
  • 4
  • 10
7
votes
1 answer

Visual Studio 2010 deployment script creates objects in wrong order - trigger after stored procedure

I created a view that selects from multiple tables in a complex query. Due to the complexity, I created insert/update/delete INSTEAD OF triggers to handle these operations on the view. I also created stored procedures that update the view. When I…
Dor Rotman
  • 243
  • 1
  • 2
  • 6
7
votes
4 answers

Are there any problems with deploying an SQL Server database to a production server by taking a backup?

This is a slightly loaded question in that I have already assumed that the described scenario is wrong. A DBA is deploying an application I have written that includes an MS SQL Server 2008 database. He has asked me to take a database backup from my…
Stephen Hewlett
  • 173
  • 6
7
votes
2 answers

How to simplify SSAS deployment from DEV to PRO environment

Here is my issue: In my company, there is a team of developper who creates cubes, dimensions(...) in SSAS in a DEV environment (let's call it SSASDEV). This environment is bounded to a SQL Server database in DEV (let's call it SQDEV). My job is to…
el_grom
  • 133
  • 2
  • 2
  • 4
7
votes
1 answer

Is there a way to give GRANT OPTION recursively for subsets of permissions?

In SQL Server, I would like to create a role that has the ability to manipulate database objects as well as create other roles and grant those roles subsets of its permissions. CREATE ROLE deploymentRole; CREATE ROLE subRole; GRANT SELECT TO…
SolsticeShard
  • 71
  • 1
7
votes
3 answers

Property class Length Annotation PersistedResolvableAnnotation

I am trying to deploy an ssdt project using sqlpackage.exe utility. I get the following error (in German): Fehler bei der Erstellung des Bereitstellungsplans. Die Bereitstellung kann nicht fortgesetzt werden. Die Property-Klasse Length ist nicht…
Magier
  • 4,585
  • 6
  • 37
  • 75
6
votes
2 answers

Deployment script always re-create constraints and indexes

When generating a deployment script from SSDT it always generates code that drops the foreign key constraints & indexes then creates again those constraints and indexes. How to remove the code that drops and recreates those objects when generating…
Emman Bangis
  • 71
  • 1
  • 3
5
votes
1 answer

Handling SQL updates for production deployments

I'm researching for quite a long time now (about two months) and haven't found a good approach for this, so I'll ask you experts out there in the hope of some enlightenment. I run a pretty traditional LAMP web application in the cloud. The source…
Deny Dias
  • 51
  • 4
1
2 3 4 5 6