﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum / StrataFrame Database Deployment Toolkit / Enhancement Requests  / Allow "Sharing" of parts of the Database / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>forum@strataframe.net</webMaster><lastBuildDate>Fri, 21 Nov 2008 13:34:51 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Allow "Sharing" of parts of the Database</title><link>http://forum.strataframe.net/Topic2282-12-1.aspx</link><description>Similar to object inheritance, any changes you made to the "core" would then be inherited within the other profiles.  Not a bad idea.  I'll bring it up in the next meeting.</description><pubDate>Fri, 18 Aug 2006 13:55:50 GMT</pubDate><dc:creator>Ben Chase</dc:creator></item><item><title>Allow "Sharing" of parts of the Database</title><link>http://forum.strataframe.net/Topic2282-12-1.aspx</link><description>Our current vision is to have 3 systems, that do slightly different things&lt;br&gt;&lt;br&gt;Each should be based on some core tables (These are core due to not needing changing between the 3 systems)&lt;br&gt;&lt;br&gt;Would be nice if I could package the "Core" system along with System1&lt;br&gt;&lt;br&gt;Would like to be able to Alter/Fix/Adjust the core system in any of the 3 "Specific" systems, then packaging up the "Core" along with one (And only one) of the "Specific" system&lt;br&gt;&lt;br&gt;So really looking for a way to "Share" the common elements, seems that the Toolkit only will deploy changes made within it.  This will require me to go and make the same change 3 times, rather than the "Inherentance" model usable within the business rules.&lt;br&gt;&lt;br&gt;I could consider creating a seperate DB for "Core" items, but since the Schema / Proc changes are kept outside of SQL server, doesn't seem to allow the sharing there either.&lt;br&gt;&lt;br&gt;So not sure of best way of doing this (Maybe - Package of packages?  Not sure)&lt;br&gt;&lt;br&gt;As an example, I'm going to create a table w/ an auto-numbering key.  Then the reference to the table can be specific to the "Specific" system (System1 calls the key "Customer ID", System2 calls it "Customer", System3 has a 2 part key of "Partner/Facility".  All need the same "Core" data, but key structure is slighly different).  Plan on having a "Specific" table that provides a relationship between the "Specific" key info and the "Shared" key info.&lt;br&gt;&lt;br&gt;To add to this fun, each System will have somewhere between 3 and 7 different key possibilities, hope to just need to create a "Link" table per different possibility, and use Business object inherentance to deal with this&lt;br&gt;&lt;br&gt;So base idea is to have some way of "Sharing" SOME schema between different deployment packages.  Ideally would be able to combine multiple "Development" packages into a single "Deployment" package</description><pubDate>Fri, 18 Aug 2006 12:39:27 GMT</pubDate><dc:creator>Jim Schepflin</dc:creator></item></channel></rss>