Questions tagged [version-control]

Version control for database structural and code components.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
763 views

Are there any databases with out of the box Point-in-Time-Architecture support?

I am looking for the descriptive term of a database system (available in the cloud, or to be deployed on a local server) that has build-in support for a point-in-time (PTA) architecture. I am not sure ...
1
vote
3answers
163 views

DB2, How to save all stored procedures as files

How does one extract all stored procedures from a DB2 schema as individual files (without using Data Studio so it can be scripted). I need them all so I can uploaded to source control. I have found ...
1
vote
1answer
237 views

postgresql materialized views vs versioning

I came across a pickle when dealing with question from one of our dev concerning postgresql and materialized views: can I refresh materialized view with my application user? well according to docs (...
1
vote
0answers
152 views

Unable to deploy single SSIS package into SSISDB when referencing parameters

I'm attempting to deploy a single package into an Integration Services Catalog using the project deployment model in SQL 2016. This however is giving me some grief, as I've configured environmental ...
0
votes
1answer
23 views

pg_dump - how to split it into directories and files?

I am looking for a way to dump PostgreSQL12 database model into a directory/file structure, instead of a single file - for versioning purposes. I found this old thread, which mentions this exact case ...
0
votes
0answers
31 views

Versioning in parent child relationship - stale foreign keys problem

I have modeled a parent-child relationship in the following way: Following are my entities: Task: Holds details of the task. Event: Holds an event of status change of a task. For example, task_1 ...
0
votes
0answers
12 views

Upgrade DAC wizard rebuilds schemabound views for no apparent reason

We recently did a deployment that included upgrading a database via DACPAC. We extracted the script from the SSMS Upgrade DAC wizard, removed the objectionable parts (dropping users, extended ...
0
votes
0answers
90 views

Liquibase on Oracle SQLcl - table and index drops not being propagated

I've been using Oracle's SQLcl, specifically the lb command to use Liquibase, for the last day or so to use for versioning my development, staging and production databases, which are using Oracle's ...