Post reply

making two databases work together

  • June 14, 2005 at 7:23 am

    #87976

    Hi,

    I would like to know if it is possible to make it work with 2 twin databases within SQL Server 2000. Thus, one database will have all data sent by the application and the other will have certain data as long as it is the twin of the first database in structure. Is this possible and how?

    Thanks.

  • June 14, 2005 at 7:25 am

    #565285

    Why do you want to do something like this?

  • June 14, 2005 at 7:35 am

    #565292

    I want to develope a new application with the second database but also I need most of the data in the first database and I would like to update the second database online. Do you have a solution for this problem? Online updating a database by getting certain data from other database.

  • June 14, 2005 at 7:37 am

    #565293

    Why can't you use the same database for the 2nd application?

    How will you use the first database?

  • June 14, 2005 at 7:41 am

    #565294

    I am just searching a better solution in order not to make the new application sort all the millions and millions of data to find a hundered. So you have a solution?

  • June 14, 2005 at 7:48 am

    #565297

    You can use the data of database B when you are in database A, so I definitly wouldn't copy all the data (especially if you have millions of rows).

  • June 14, 2005 at 7:54 am

    #565308

    Ok. thanks for your concern. But I still want to know if it is possible or not to make the databases be work online together? Maybe with triggers or procedures?

  • June 14, 2005 at 8:03 am

    #565318

    try this :

    use pubs

    go

    Select * from northwind.dbo.Categories

    It works, but I don't know enough about your design to make a final statement.

  • June 14, 2005 at 8:06 am

    #565320

    The problems comes from the fact that I don't know what application needs to do with the data, and where that data is sitting. The server, and the applications can certainly have more than 1 databases running at the same time.

  • June 15, 2005 at 1:28 am

    #565560

    Not sure if I completely understand what you want to do, but if you want to copy a portion of data from databaseA to databaseB then you could use DTS or a stored procedure to - select top 100 * into databaseB.dbo.tableA from databaseA.dbo.tableA for each table you want.

    If you are wanting the total set of data and automated updated of databaseA to databaseB have a look at 'Replication' in Books Online.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply