The database-deployment tag has no wiki summary.
0
votes
0answers
2 views
Where Does sqlpackage.exe Store Database Backups?
I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags ...
0
votes
0answers
20 views
VisualStudio2010 db deployment with user defined variables
In my stored procedures I need to connect to some other database (same server). The name of this database is different depending on client and environment. I would like to avoid using sp_executesql ...
1
vote
1answer
45 views
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 ...
0
votes
2answers
78 views
What is the syntax for adding multiple arguments onto the “Variables” parameter in sqlpackage.exe?
I am using SqlPackage.exe for my deployment. I have read the documentation here for the usage of SqlPackage.exe.
The documentation only states the synax for one variable:
Specifies a name value ...
0
votes
1answer
61 views
what is the risk of using sparse columns instead of normal relational tables?
I have three table that related to one table,in my new design I want to replace the relationship by using sparse columns.
you Can see diagram below.
I know I would have Redundancy.but i want to ...
0
votes
1answer
107 views
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!
1
vote
1answer
196 views
How to limit post deployment script to run only once in Visual Studio database project
We have a post deployment script in our visual studio database project. It populates lookup tables with data. The problem is that every time we change schema and generate update script, post ...
1
vote
1answer
390 views
Visual Studio Database Deployment - Script not running in SQLCMD mode
I have a SQL Server 2008 Database Project that I'm attempting to deploy using Visual Studio 2010. When I click deploy, the build works fine, but after it creates the deployment script and begins to ...
3
votes
1answer
273 views
How do you prevent a VS2010 Database Project Deployment from generating a drop database?
Suppose you have a database project and you do NOT have "Always re-create database" checked off in your Database.sqldeployment settings. And suppose you deploy to a server that already has a database ...
2
votes
1answer
829 views
Update database feature not working in Publish Web dialog in Visual Studio 2012
I'm developing an ASP.NET Web Forms application under Visual Studio 2012. I'm using Web Deploy and Publish Web dialog for application deploy. I'm trying to deploy a database schema using the Update ...
0
votes
1answer
99 views
VS 2010 Database Project deployment is not deploying indexes
I have a database project in Visual Studio 2010 that deploys tables and stored procedures to the server without issue. However, none of the index scripts get included in the sql output script and ...
4
votes
4answers
415 views
Execute SQL Script with .net executable
I have a c# .net application that has been distibuted separately to several clients, Once in a while we add some new features or fix some bugs and frequently make changes in the DB. I use click once ...
0
votes
2answers
93 views
Distributed Database
I NEED YOUR HELP
ANY IDEA ANY SOLUTION
SCENARIO:
An organization suppose Jason industries have its branches in different regions of country. In each branch there is a local database where they ...
2
votes
1answer
2k views
Deploying database and web projects during TFS build process
I have a mixed solution with a couple of Web applications and SQL Database projects.
I also have a remote test server with MS SQL 2012 and IIS 7. The TFS build server is on another machine. All the ...
0
votes
1answer
241 views
How do I troubleshoot when VSDBCMD does not deploy, but shows no errors?
I am trying to use VSDBCMD.exe (Visual Studio 2010 version) to deploy the output of a database project. I am including the /dd:+ switch in my command line. Every time I run the command, I get one ...
