Consolidation of table entries in multiple database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Consolidation of table entries in multiple database

  1. #1
    Amy Guest

    Consolidation of table entries in multiple database


    Anyone have an easy way of consolidating multiple tables from multiple database
    that have the same fields to a single master table? For example, there are
    3 databases that each have a table called dataentry1. The table has the
    same fields in each of the databases. Is there a trigger that I could insert
    so that all the records from the 3 tables is inserted into a single master
    database and table?

    Database 1 dataentry1
    Database 2 dataentry1
    Database 3 dataentry1

    Please let me know. I appreciate all the help I could get.
    Amy

  2. #2
    Amy Guest

    Re: Consolidation of table entries in multiple database


    Never mind. I wrote a trigger to update a master database.

    "Amy" <amyt@onebox.com> wrote:
    >
    >Anyone have an easy way of consolidating multiple tables from multiple database
    >that have the same fields to a single master table? For example, there

    are
    >3 databases that each have a table called dataentry1. The table has the
    >same fields in each of the databases. Is there a trigger that I could insert
    >so that all the records from the 3 tables is inserted into a single master
    >database and table?
    >
    >Database 1 dataentry1
    >Database 2 dataentry1
    >Database 3 dataentry1
    >
    >Please let me know. I appreciate all the help I could get.
    >Amy



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