Results 1 to 2 of 2

Thread: Database copy

  1. #1
    Join Date
    Apr 2004
    Location
    Italy
    Posts
    7

    Unanswered: Database copy

    Hi to all,

    i would like to know how i can solv e my problem.

    I have two databases, one is a work in progress(from now WIP) and the other is a container about all the data (ALLDATA). The databases have the same structure, the first is stored in a MSDE 2000 and the second in a SQL Server 2000.

    When something happen, i copy a part of data from the WIP to the ALLDATA and i clear the WIP from the copied data.
    Now i'm using the insert into instruction for each table.

    Is this method right to work?
    Can you suggest me something differen?

    Thank you.

    Emanuele

  2. #2
    Join Date
    Feb 2003
    Location
    Amsterdam
    Posts
    8
    [qoute]When something happen, i copy a part of data from the WIP to the ALLDATA and i clear the WIP from the copied data.
    Now i'm using the insert into instruction for each table.[/quote]

    I am sorry but I do not quite understand what you are doing. Can you explain?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •