I have been working with SDDM 4.0 and it looks like the best candidate to replace our current Oracle Designer Repository We are a small shop with 2 DBA's and only internal customers. I have developed a couple of small designs from scratch as a proof of concept.
Now I need to load all of our current designs into SDDM and synchronize them with the existing data dictionaries.. We are not using versioning in Designer but plan on versioning in SDDM in lieu of a repository and to maintain development and production branches.
The forum thread Advice/Recommendation please? How to best handle big models with various schemas? was a big help and I plan to implement most of that approach but I need advice on merging and versioning everything. I initially worked with Subversion with SDDM 3.3 about a year ago but decided to defer Subversion until I had time to work with the tool without that extra complication. Now I need to bite the subversion bullet and I am hoping to avoid obvious dead ends with the help of the community.
Current State Of Designer
1 work area
13 Application Systems for custom applications
1 Implementation Application System for deployment from DB Admin tab
4 Oracle Implementation Databse (22.214.171.124) pairs (DEV/PROD)
1 MS SQLServer Implementation Database (2008 R2) (only one database and 4 tables so this is not critical and can be manually synched)
Current State of the database
Designer Repository is not completely in synch with the Oracle data dictionaries.
There are development modifications in Designer *not* implemented in any database.
There are development modifications in Designer implemented in any database.
There are development modifications in Designer implemented in the development database
Development database has differences that are not in the repository (Not all modifications made in the database are in Designer).
Production database has differences that are not in the repository (Not all modifications made in the database are in Designer).
Development and Production databases also have differences
What should be the order of importing and how do I synchronize Designer, Development DB and Production DB? What is possible? At what stages should I merge and check into Subversion? I am trying not to get wrapped around the axle. I have a month or so to get this done.
A) Import one, merge it, import the next and merge it and import the last and merge that into one Relational, version then engineer to logical?
B) Import them into different Relational Models, Engineer to one Logical, Engineer Logical to a new Relational and version
C) Some other approach?