Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-13 : 08:07:10
|
| Gregor writes "We are replicating data from one SQL database to a different SQL database (on the same server, MS SQL 2000).For this, we use Transactional (Push) Publications and DTS packages (with active queries and ActiveX script).In the ‘old’ database, we have one table witch data goes into two tables in the ‘new’ database. These two tables have a relationship (table 1 = Header, table 2 = Details).We use for each table in the new database a publication with a DTS package (the articles in the publications are partitioned horizontally (only active records are included)).If the state of a record in the ‘old’ database is changed from ‘not active’ to ‘active’, it is in the partition and must be replicated via the two publications.The problem is that the publication of the details is run first, resulting in an error, because the details need a reference to the header (that is not yet in the ‘new’ database).Can we specify the order of the publications? This would solve our problem.If we cannot specify the order of the publications, what is the best way of solving this problem?Thanks for your help!" |
|
|
|
|
|
Replication: how to specify publication order?