The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
11 views

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 ...
1
vote
0answers
25 views

Best practices for deploying and updating SQL Server as part of code deployment

I am a (windows) developer trying to determine the best approach for publishing DB schema changes requiring data transformations as part of my code releases. I have tried googling but did not find ...
0
votes
0answers
22 views

push mysql db to production without the risk of data loss

We are using mysqldump 'backup'and 'restore' commands,in order to push the DB between staging > production ( backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore:# ...
1
vote
1answer
81 views

Enable TDE When Publishing DACPAC

In the database properties in Visual Studio there is a checkbox for encryption. I'm not sure if I check this if it will enforce encryption when doing a DACPAC deploy. What I would really like to do is ...
0
votes
0answers
40 views

Howto create useful dacpac versioning with along SSDT deployment?

Took me almost one day to go through lots of articles and blogs to realize check-in driven continuous integration with SQL Server Database Projects (SSDT) using TFS and msbuild. Now one this is ...
0
votes
0answers
18 views

Is automatic disabling of DML triggers possible during SSDT publish?

During ssdt deployment I am concerned about having DML triggers in place on tables that may slow down performance of table recreation a lot. We are facing the issue that the column order in the ...
0
votes
0answers
19 views

Howto create a detailed report of all actions by publishing with sqlpackage.exe?

When publishing ssdt projects from visual studio I realized that a "deploymentreport.txt" file is created on hard disk. sqlpackage.exe can be executed with the action "DeployReport" that creates a ...
7
votes
2answers
282 views

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 ...
0
votes
2answers
40 views

SSDT table column order

I realized that the behaviour of SQLPACKAGE.EXE changes depending on what changes have been made to a table schema: Adding a new column at the end of the table: "Table is changed" Removing a column ...
0
votes
1answer
49 views

Staging MySQL databases

I'm building a Web/Web service application based on a number of (MySQL) databases. The databases are all built from externally derived data from dozens to hundreds of sources. My general plan is to ...
0
votes
1answer
28 views

Howto remind and restore recovery mode during SSDT deployment?

Due to deployment of a SSDT database project I would like to be able to switch the target database's recovery mode from FULL to BULK LOGGED and back after the deployment finished in order to do any ...
0
votes
1answer
33 views

SSDT Publish Window: What does checkbox ENABLE mean?

In the Visual Studio 2015 SSDT "Advanced Publish Settings" Window, Tab General, "Advanced Deployment Options" there are several checkboxes in the column "ENABLED" we can check or uncheck. Most of the ...
2
votes
1answer
93 views

Run aspnet_regsql.exe from SQLCMD Post-Deployment Script

I am trying to create a Post-Deployment script in SSDT that will include the creation of an ASP.NET Session State database to make sure everyone has this thing in place after deployment of my database ...
1
vote
1answer
59 views

Post data deploy in SSDT

I need to create post deployment script which will upload data from .csv file to my database. But I can't understand how can I do this. When I tried to deploy my project on my server I receive this ...
2
votes
1answer
391 views

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 ...
0
votes
1answer
124 views

Web application for Software as a Service - Shared database or Multiple Databases?

(I am not sure if this is the best place to post this question. If not, please redirect me to the appropriate stack exchange site.) I am looking to deploy a web application for multiple clients. The ...
2
votes
1answer
125 views

SSDT: Create User in a database not being part of the project

I want the user of my SSDT Database Project to be created as a user in another database on the same server and give it permissions to connect and add it to the db_datareader role. I failed to do so. ...
0
votes
1answer
604 views

The application is not installed - Visual Studio 2013

I need to deploy packages using visual studio 2013 but I am seen this message, the application is not installed, as you can see on the picture below. what do I need to install?
4
votes
2answers
398 views

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 ...
1
vote
1answer
165 views

SQL User Permissions for Continuous Integration via DbUp and Octopus

Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. We have created a Domain user which will utilized to do the SQL Database ...
0
votes
0answers
251 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer)

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...
2
votes
1answer
221 views

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 ...
0
votes
1answer
482 views

MySQL Workbench - “deploying” schema into a real database

a noob here, finding my way around. So, how can I "transfer, deploy or whatever the right term is" the database tables, fields, etc. that I have created with Workbench into a real database? The dB I ...
1
vote
1answer
255 views

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 ...
0
votes
1answer
229 views

Mongodb deployment best practice for dual nodes?

I have two nodes and I'd like to deploy mongodb on them. It seems there're two methods: Deploy as master-slave. But it's marked in the official document as "legacy". Deploy as a replica set. But a ...
2
votes
2answers
301 views

How many database servers do I need?

This may be a no-brainer to some of you, but I am a newcomer to DBA and this question popped into my head and I couldn't answer it on my own and so I am turning to the experts here. I have a app that ...
1
vote
2answers
1k views

Replication Blocks Code Deployment

We have a database (SQL Server 2008r2) that is being transactionally replicated, namely tables, sprocs, views, indexed views and UDFs only, to another server (SQL Server 2014) as part of a cautious ...
3
votes
0answers
3k views

SQL Server Projects in Visual Studio 2013 [closed]

I am looking for information regarding Visual Studio 2013 and working with SQL Server projects. We are currently working on a project where we are using a database that already exists and is used by ...
1
vote
0answers
778 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
3
votes
1answer
742 views

DbUp and script directory

I'm using DbUp, starting from the example I've created a C# program. The example suggest me to put all scripts under Scripts directory. Ok, this is done but, when script number will grow up that ...
2
votes
1answer
4k views

Why does SQL Server fail to create a procedure referencing a linked server?

Red Gate Deployment Manager (RGDM) today failed with a "login failed" error even though it had administrative control of the target server: 2013-11-04 17:13:22 +00:00 INFO Creating ...
7
votes
4answers
681 views

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. ...
1
vote
1answer
3k views

Schema Change/Update script for Database deploy [closed]

I have a need to change the database schema . I'm planning to write Schema change and update scripts for tracking database changes and updating them. I followed Versioning Databases – Change Scripts ...
2
votes
1answer
290 views

Deploying to SSIS catalog and get permissions error

When I attempt to deploy to SSIS 2012 Catalog on new server I get an error. I have researched it on the web for several hours and all of the information available online does not fix my issue.
4
votes
2answers
2k views

How to setup SQL active/active cluster to achieve Blue / Green instance switching?

I am wondering if anyone has ever used a multi-instance cluster (nee 'Active/Active') to achieve blue/green (or A/B) deployment scenarios, and what the best way of configuring it is (using SQL 2012 / ...
4
votes
1answer
327 views

Deployment Manager Vs DBA Cage Match On Pushing Releases To Prod

Our company has now hired a full time release engineer for the MS Windows side and we were thinking of a release management process for MS SQL Server. IF we have confidence in their abilities to ...
3
votes
1answer
502 views

Rolling Back DB Changes After Deployment Edge Cases

I manage a mixed DB environment and our programmers could use some good rollback options. I was thinking of using SQL Compare, Red Gate Source Control, and a few other tools but I can't figure out ...
6
votes
1answer
6k views

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 ...
3
votes
2answers
1k views

Alternate ways to increase column size

I have a database that is in production, and in some instances will have millions of records. It has been requested that we increase the sizes of several columns, which is for the most part pretty ...
2
votes
2answers
636 views

SQL server job deployment

I have a SQL Server job which has got different steps, including running a SSIS package. Currently it is on my PC (my local instance). I should deploy it to UAT and assume some steps need to be ...
2
votes
1answer
99 views

Microsoft SQL Server 2008 encryption over multiple DB versions

I have about 5 clients deployed running different versions of SQL Server 2008 (Some standard, some enterprise, etc.) And I am being tasked with encrypting the data so: The software we are using can ...
1
vote
1answer
158 views

Rolling changes to production databases

We're currently using Clustering to do fail over for our SQL environment. There are two servers that use the same shared drive. The SQL database is on a shared drive. This provides OS and hardware ...
28
votes
1answer
9k views

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 ...
7
votes
1answer
1k views

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 ...
26
votes
1answer
10k views

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 ...
2
votes
2answers
325 views

how to generate scripts for database objects specific to an application?

There was a application which, earlier, pointed to a database. It used a specific set of tables. Those tables had triggers, constraints, etc. There were also stored procs which insert data into these ...
2
votes
1answer
2k views

Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2

Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At the client side it is very slow to open and refresh Design center and control center ...
3
votes
1answer
5k views

“Procedure: XXXX has an unresolved reference to object XXXX” errors

After using for some time MS SQL Server Management Studio for creating and editing databases I tried to use Visual Studio 2010 "SQL Server 2008 Database Project" for this. I used the SQL 2008 Wizard ...