Questions tagged [database-deployment]

55 questions
0
votes
1 answer

SSDT/ VS2015 Database deployment -- publishing is ignoring nested views

I am attempting to gain some knowledge and use cases on SSDT Database development and deployments and strugling with some deployment issues. Specifically when using nested views. For some unknown reason when attempting to deploy / publish the files…
0
votes
1 answer

How to Package/Publish SQL databases with ASP.NET MVC 2 Website?

I'm trying to deploy my ASP.NET MVC 2 Website for the first time on a local IIS 7 server, which is configured and running. I've made successful deployments using the Web Deploy option without the databases (so the site isn't fully working yet). Most…
randomguy
  • 12,042
  • 16
  • 71
  • 101
0
votes
1 answer

How to provide an option in a Setup project dialog box where the user can choose the instance names from the local machine or a server?

Suppose I have a dialog box for giving an instance name and I want to see what are the other instances available in the local machine or the server and what if the user has both SQL Server 2005 and SQL Server 2008 installed in his system and I want…
0
votes
1 answer

Can a mysql backup be transfer by copying and pasting data files from the mysql dir?

I need to reformat my computer and reinstall the OS. I have plenty of databases that are connected to sites running on my XAMPP stack. If I copy an paste the data files from the mysql folder into a new XAMPP stack, will the databases be preserved?…
Hoytman
  • 1,722
  • 2
  • 17
  • 29
0
votes
1 answer

Code first migrations - how to rollback first migration

Using code first migrations it is trivial to migrate to any given migration by using -TargetMigration [MigrationName]. But how do you rollback to before the first migration? What migration do you target for that? The first migration has a Down()…
0
votes
1 answer

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 therefore are not getting applied. I have been unable…
norepro
  • 777
  • 2
  • 9
  • 18
0
votes
2 answers

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 maintain their data locally. Suppose one branch in…
-1
votes
0 answers

Jenkins + Gitlab | Problem with database deployment

I have a sudden problem publishing a database for unit tests (C#, .NET app) by Jenkins on server (Windows Server 2016, Visual Studio 2022,Microsoft SQL Server Express 15.0.4153.1). Sorry if this is trivial question but I'm out of ideas. This is log…
-1
votes
1 answer

Which tool for database vesioning to use? liquibase vs mysql binary logs

I'm trying to build a process of refactoring, testing and deployment of my databases. After some kind of research I found liquibase as a nice tool for managing my database versions. As well similar kind of jobs could be done with just mysql binary…
-2
votes
1 answer

Visual Studio 2015 Database project

I need to exclude some tables from publishing in a database project, the main idea is to publish only a subset of tables depending on the build configuration, if it's Debug I want to publish all the tables but if the configuration is Release I want…
1 2 3
4