1. Ralf Ludwig
  2. Valentina Studio
  3. Montag, Juli 02 2018, 08:00 AM
  4.  Abonnieren via E-Mail
Hi,

is there any option to save the SQLDiff result as separate scripts by the type of objects?

A short description of the background: it would be helpful for our continuous integration and deployment architecture. We use a deployment service, which applies scripts automatically, if a new application version is deployed, if it is run locally or at runtime for a new empty db. We design the db by Schema. But deployment service needs first e.g. all tables from all Schemas, then constraints, and so on. So currently we have put the scripts into folders ordered by Schemas and then folders by object types.

Ralf
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Ralf,

No, currently it is a single script.

Something like that?
https://www.dropbox.com/s/8c0p907p574w4fj/Screenshot%202018-07-02%2012.36.31.png?dl=0
Kommentar
There are no comments made yet.
Ralf Ludwig Akzeptierte Antwort
Hi Sergey,

thank you for your swift response. Yes, something like in your screenshot.

I have added a screenshot, how it looks like in our repository. So this is our hierarchy structure:
<projectname> <repository> <module (Schema)> <version> <objecttype (Table, View, Contraints,...)> <object sql script>
Anhänge
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories