Stack Overflow
Stack Overflow

Questions tagged [dbdeploy]

23 questions
8
votes
5 answers

How to handle multiple db alter scripts coming from different Git feature branches?

A bit complex to describe, but I'll do my best. Basically we're using the Git workflow, meaning we have the following branches: production, which is the live branch. Everything is production is running in the live web environment. integration, in…
Tohnmeister
  • 468
  • 1
  • 5
  • 14
6
votes
6 answers

Getting Phing's dbdeploy task to automatically rollback on delta error

I am using Phing's dbdeploy task to manage my database schema. This is working fine, as long as there is no errors in the queries of my delta files. However, if there is an error, dbdeploy will just run the delta files up to the query with the error…
Gordon
  • 312,688
  • 75
  • 539
  • 559
3
votes
3 answers

How to create DacPac from script files to automate DB deployment?

I need to automate SQL Server DB deployment using Azure DevOps. I don't want to give any alter statement. I will have a folder structure with tables, stored procedures, views & functions in repository. Every folder will contain only create scripts.…
VKD
  • 633
  • 2
  • 12
  • 28
3
votes
2 answers

SQL Server DB changes deployment

I am struggling to keep up with DB changes and how to cleanly maintain and deploy DB changes from Dev to PRD from one release to another. Currently, I use a SQL script to figure out what has changed since the last release; Procs and Views are the…
Robert Dinaro
  • 508
  • 3
  • 8
  • 23
2
votes
1 answer

controlling data when deploying databases with dbdeploy

We work with Phing's dbdeploy task to do version control of our PostgreSQL databases, which altogether is a nice way of working. I don't really have a lot of problems with database versions after we started working with it, apart from one nagging…
Berry Langerak
  • 18,561
  • 4
  • 45
  • 58
2
votes
1 answer

How to deploy a microservice ( possible multiple instances) dependent on database in the same kubernetes cluster?

I wanna run a microservice which use DB. DB need to deploy in the same kubernetes cluster as well using PVC/PV. What is the kubernetes service name/command to use to implement such logic: Deploy the DB instance If 1 is successful, then deploy the…
J.J. Beam
  • 2,612
  • 2
  • 26
  • 55
2
votes
1 answer

SQL Server 2000 - How to restore the prior state of connection level settings

I'm using DBDeploy.NET for change control management in my T-SQL codebase. DBDeploy works by the developer maintaining a numbered set of change scripts. When a deploy is triggered (via NAnt), DBDeploy looks at a changelog table and determines…
jennykwan
  • 2,631
  • 1
  • 22
  • 33
2
votes
1 answer

How to solve SchemaVersionTrackingException in dbdeploy due to no default value in delta_set?

I am trying to do automatic DB migration. I am using dbdeploy for the same. I followed the steps in this link http://blog.codeborne.com/2012/09/using-dbdeploy-in-gradle.html I created the change log table as: CREATE TABLE changelog ( …
user1788306
  • 21
  • 1
1
vote
1 answer

DbDeployer - MySQL instance - Grants for new databases (or root user)

This question relates to Dbdeployer The section in question: Users: root, with the default grants as given by the server version being installed. I have an instance installed on port 5730 and port 5731 respectively. (Corresponds to MySQL 5.7.30…
CvRChameleon
  • 367
  • 1
  • 5
  • 29
1
vote
3 answers

Using DBDeploy in Gradle with hibernate as the ORM

I am looking to use a versioned database migrations tool like DBdeploy in a java project which uses Hibernate as the ORM and uses Gradle as the build system. I am unable to lookup any documentation on running DBDeploy on Gradle. Also is there a…
Ritesh M Nayak
  • 8,001
  • 14
  • 49
  • 78
1
vote
2 answers

Unable to run the dbdeploy component using msbuild on windows server 2012 where SQL Server 2012 is installed

I am trying to run the dbdeploy component using MSBuild on a Windows server 2012 where SQL Server 2012 is installed. On running the msbuild script I am getting the following error: "E:\TestDeployment\Test.proj" (UpgradeDatabase target) (1)…
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
1
vote
1 answer

Best practice to upgrade a SQL Azure DB?

I am trying to upgrade an Azure DB in a continuous release scenario. The DB lives in SQL Azure and its size keeps growing. Now it's about > 50G. In my previous on-premise experience, I usually backup the old DB in a compressed format and save it to…
smwikipedia
  • 61,609
  • 92
  • 309
  • 482
1
vote
1 answer

dbdeploy error with --// in deploy-file

I am generating deployment-files for my mysql-database with phing and dbdeploy. The output of a dbdeploy-file that is generated looks like the following: -- Fragment begins: 8 -- INSERT INTO changelog …
Niels Maseberg
  • 33
  • 5
1
vote
2 answers

Dbdeploy maven plugin not finding changelog table

I'm using the dbdeploy maven plugin but it's throwing an error when I run a build. The error says : [ERROR] com.dbdeploy.exceptions.SchemaVersionTrackingException: Could not retrieve change log from database because: user lacks privilege or object…
Dave Richardson
  • 4,880
  • 7
  • 32
  • 47
1
vote
2 answers

Using DBDeploy.Net with Rake

We are trying to use DBDeploy.Net for managing our SQL Scripts in a .Net project. We also use a Rake script for automatic builds. I am unable to find any documentation on how to use DBDeploy.Net with Rake. Is there a nice way of getting DBDeploy…
Nima M
  • 718
  • 10
  • 18
1
2