Multiple Database Architecture


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Multiple Database Architecture

Hybrid View

  1. #1
    mholt28 Guest

    Multiple Database Architecture


    I am considering developing a two database architecture, and I am wanting
    to know any issues involved in doing this and if this is the best architecture
    to follow up with.

    Database to be supported
    MS SQL Server
    MS SQL Server with MSDE

    Database 1
    Site specific Data is imported daily from a 'master' database
    Original data is truncated
    Data is Read only
    Data is accessed through stored procedures in Database 2 only

    Database 2
    70% of tables in database 2 are mirror images of Database 1
    tables because original data must be maintained
    Data is exported daily to 'master' database'
    Data can be inserted
    Data can be deleted/updated if it has not been exported
    Data is deleted if data has been transferred to Database 1 on
    an import
    Data in Database 1 that needs to be changed is saved in
    Database 2 along with any related data
    Data is accessed through stored procedures only

    Note: currently testing viability of accessing data in Database 1 from a
    stored procedure in database 2

  2. #2
    Steve Cullins Guest

    Re: Multiple Database Architecture


    You are nuts for wanting to implement such a database. This will only lead
    to a horrible maintenance problem and portablity problem. I would hate to
    be a developer on your team.

    It should be recommended that your project lead see a psychiatrist or be
    fired for wasting development time even recommending a silly idea as this.


    "mholt28" <mholt@alliancesys.com> wrote:
    >
    >I am considering developing a two database architecture, and I am wanting
    >to know any issues involved in doing this and if this is the best architecture
    >to follow up with.
    >
    >Database to be supported
    > MS SQL Server
    > MS SQL Server with MSDE
    >
    >Database 1
    > Site specific Data is imported daily from a 'master' database
    > Original data is truncated
    > Data is Read only
    > Data is accessed through stored procedures in Database 2 only
    >
    >Database 2
    > 70% of tables in database 2 are mirror images of Database 1
    > tables because original data must be maintained
    > Data is exported daily to 'master' database'
    > Data can be inserted
    > Data can be deleted/updated if it has not been exported
    > Data is deleted if data has been transferred to Database 1 on
    > an import
    > Data in Database 1 that needs to be changed is saved in
    > Database 2 along with any related data
    > Data is accessed through stored procedures only
    >
    >Note: currently testing viability of accessing data in Database 1 from

    a
    >stored procedure in database 2



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center