Stack Overflow
Stack Overflow

Questions tagged [database-deployment]

55 questions
2
votes
2 answers

How to deploy my application if it requires a database with tables created?

I was previously using a database in SQL Server CE. That's kind of easy, because I can have a database in a simple .sdf file and deploy it with my application (either empty or with data already added). But what if I want to change the database to a…
Oscar Mederos
  • 29,016
  • 22
  • 84
  • 124
2
votes
3 answers

SQL Server: pushing development to production?

I'm currently using SQL Server Management Studio. I have a development database, and access to a live database. I just want to able to migrate my development tables to the live server. I'm consulting stack flow first, since I don't want to blow…
Nick
  • 41
  • 1
  • 4
2
votes
1 answer

How to run database sql script in appHarbor SQL Server

I have successfully deployed my asp.net web form application on appHarbor and also installed SQL Server. But I don't know how to make database as I could not find any query box of shell where I can run my schema script.
Abdullah
  • 2,015
  • 2
  • 20
  • 29
2
votes
3 answers

How do you manage your sqlserver database projects for new builds and migrations?

How do you manage your sql server database build/deploy/migrate for visual studio projects? We have a product that includes a reasonable database part (~100 tables, ~500 procs/functions/views), so we need to be able to deploy new databases of the…
Rory
  • 40,559
  • 52
  • 175
  • 261
2
votes
1 answer

Port number that SQL database project uses for deploying database

I want to know which port number uses a dbproj(Database Project) in visual studio 2010 to deploy a database in a remote server or how can I find that info thanks!
Jawen
  • 1,416
  • 1
  • 14
  • 26
1
vote
0 answers

Database project generate deployment script without any database creation

This may be a stupid question or it might be that I am just not googling with the right strings. I am trying to have my database project generate a deployment script that does not contain any create database statements. Basically we are looking…
Ambro
  • 73
  • 1
  • 9
1
vote
1 answer

Deploy a database project build output (dbschema & co) to various databases

I am trying to build a database project, and then use the output along with VSDBCMD to deploy it to different databases. I have added different sqldeployment & sqlcmdvars files corresponding to the environments I aim, but I am not able to change the…
Iulian Ilies
  • 265
  • 2
  • 19
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
2 answers

TFS2010 Team build - how to deploy databases before running unit tests

I followed How to prepare database for TFS deployment walkthrough and my build script successfully deploys the database at the end of the build process. However, I need the database to be deployed before running unit tests. I tried copying the step…
laconicdev
  • 6,360
  • 11
  • 63
  • 89
1
vote
1 answer

how to deploy asp.net website in intranet- Copy paste folders

I am new to web developing and some how managed to create one web page with SQL database. Now I would like to deploy my website in localhost server by that users who are having access to that server can use the website. I did some search and…
user11171114
1
vote
1 answer

When relating two tables, should you do a composite key, or primary/foreign key separately?

What is the industry design standard for representing the relationship between two tables? Should you use a composite key, or a primary key and foreign key separated? Are there performance differences between the two options? For example, say you…
Corey P
  • 955
  • 1
  • 14
  • 23
1
vote
3 answers

VSTS build - Incremental database deployment in distributed environment

I have a sql server database working with a .net 2015 mvc 5 application. My database code is source controlled using SSDT project. I am using SqlPackage.exe to deploy database to the staging environment using .Decpac file created by the SSDT project…
Rupendra
  • 608
  • 2
  • 11
  • 42
1
vote
1 answer

modify encoding for database deploy script

Is there a way to change the encoding for the deploy script generated by Sql Server Data Tools from UTF-8 to ANSI? The problem that I have is that I have a string in a function that contains the caracter "è" and in the generated deploy script a box…
Buda Gavril
  • 21,409
  • 40
  • 127
  • 196
1
vote
2 answers

Custom script files in VS2012 Sql server project

I am supposed to migrate a database into VS2012 sql server project. I have already imported all the schema from the target database. The seed data will be added to the a Post-Deployment script in the project. However I also foresee lot of scripts…
BatNetMan
  • 23
  • 3
1
vote
1 answer

Deploy database project without knowledge of target database

I've got a question. I'm used to using Teamcity + Database project which was able to deploy the database to all of the DTAP servers. I loved the way that worked - it allowed me to deploy to production weekly within 2 minutes. Now I'm working at a…
Jochen van Wylick
  • 5,303
  • 4
  • 42
  • 64
1
2
3 4