DDT Database Creation / Updates


Author
Message
Matt Tabone
Matt Tabone
StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)StrataFrame Novice (96 reputation)
Group: Forum Members
Posts: 16, Visits: 102
Quick question and I apologize if this has already been answered.

Example - DDT has been used to create a new SQL database. Now I've made changes in the DDT and I apply those changes to my SQL database.

Question - How does the DDT keep track of updates, revisions, etc? More important, How can I check that outside the DDT in my Strataframe/VB.net app?

I'm working on a merge application that will take a database and import it's data into another database and I want to be able to check that the databases are a matching schema and then store that schema version number into a config database.

Thanks
Matt
Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Matt Tabone (3/28/2012)
There is a way that the DDT is looking at the target database to determine that the database needs or does not need updating. Is there no actual value stored into the SQL database to check against? How does the DDT qualify an update is needed? What does it look at on the receiving end to say you are behind a version or you are fine?


As Ivan explained, the "Object Name History" will be used to keep the database updated as needed.  My implementation is more for me (the developer) to have control on when to execute the update instead of running the update all the time just to make sure the database is in sync.  I have some applications generating millions of records and a simple field change can take several minutes to update and re-create indexes, so I need to have control using my custom version, also sometimes I don't have access to customer servers so I needed the process to be fully automatic and self aware of when it needed to execute the data update, of course customer is responsible of backing up the data before an update will be applied.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search