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

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.

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>
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Ralf,

No, currently it is a single script.

Something like that?
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.


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