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?