Questions tagged [dbdeploy]

23 questions
0
votes
1 answer

How to make a maven plugin not run on all of my project modules

I have a multi module web app that is using maven 3, an EJB, WAR, and EAR modules used to build the app. I want to add dbDeploy to my app and have tried adding the plugin and correct directories and dependencies to the top level pom file(in the…
RedbeardTheNinja
  • 192
  • 2
  • 10
0
votes
0 answers

SnowFlake DB deployment with GitLab-CI

I have multiple Snowflake accounts, having the DB creations and Stored procedures available on GitLab repo. Is there a right approach available to deploy the same using GitLab-CI where DB deploy versions can also be tracked and DB-RollBack also will…
0
votes
2 answers

I am getting error while renaming column name or column datatype for tempoal table in TFS

I am using Visual Studio enterprise 2017 (Version:15.71.1) and SSDT(Version:15.1.61804.210) and also using TFS to keep my code. In my database project all tables are temporal table. Now when i am changing column type or column name in TFS , i am not…
0
votes
0 answers

dbDeploy.net for oracle database deployment automation using powershell

I am looking for sample implementation of dbDeploy.net for oracle database deployment automation. I was able to find the github resource : https://github.com/brunomlopes/dbdeploy.net But there is no example mentioned regarding how to implement it…
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
0
votes
1 answer

How to mange upgrades for schema, table,stored procedures and other database objects for a database managed on sql azure

I have migrated the on premise database to Azure SQL Database using SSMS. For any upgrades required to the database objects like table, stored procedure, I am connecting back to the SQL Azure using SSMS and executing the change script manually. For…
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
0
votes
1 answer

Unable to create trigger via dbdeploy for postgres db

I get the following error when trying to create a trigger on postgres via dbdeploy. The issue seems to be a postgres jdbc issue rather than dbdeploy. The sql statement seems to be ignored after the first semi-colon in the sql block. Any help with…
0
votes
2 answers

How can I keep order of refactors using database refactoring software?

I have been trying to use either Liquibase or DBDeploy. I'm more drawn toward Liquibase because of its non-SQL interface (I.E. I can just use JSON or Yaml changesets). However, there is a problem I have with both of these software. Liquibase…
Parham Doustdar
  • 2,019
  • 3
  • 22
  • 41
0
votes
2 answers

How to use dbdeploy with SQL Server?

I need help in setting up dbdeploy for my SQL Server database and MySQL Server. The example in the dbdeploy website does not tell me how to set the drivers for SQL Server and MySQL. Am a bit lost. Sample scripts will be appreciated. Thanks
gath
  • 24,504
  • 36
  • 94
  • 124
1
2