Replication Strategy

I have an app that has this design: MasterDB contains all the templates used
by the app and a record of all DealDB's created, DealDb contains just the
data, imported from various sources. A new DealDB is created for every new
"deal". The app works fine in the office, now I want to extend it for out of
office(in-transit) use. My idea is to install MSDE on the users PC's and:
1. When the deal is marked in-transit the app will not allow anyone in the
office access to it. So, I want to either detach/attach the DealDB to the
local MSDE or use Bacup/Restore to local MSDE and the same coming back to the
office. Is one better/safer/less error prone then the other? Can I attach a
DB if it was never detached/ can I restore a DB to server that was not the
one it was backed up on?
2. The MasterDB will have to be replicated to local MSDE when a user puts a
deal in-transit. When the user is back in the office all changes to the
local(MSDE)MasterDB will need to be replicated back to the network version.
While the DealDB will simply be either attached or restored back to the
network.
I guess I would use merge replication for the MasterDb? Going to local would
I use Push or Pull subscription, and what about going back to network Push or
Pull?
Can someone help me out with the details, is there a script I can use?
Thanks!
Yes you can set transformations in transactional replication
"mikeb" wrote:

> I have an app that has this design: MasterDB contains all the templates used
> by the app and a record of all DealDB's created, DealDb contains just the
> data, imported from various sources. A new DealDB is created for every new
> "deal". The app works fine in the office, now I want to extend it for out of
> office(in-transit) use. My idea is to install MSDE on the users PC's and:
> 1. When the deal is marked in-transit the app will not allow anyone in the
> office access to it. So, I want to either detach/attach the DealDB to the
> local MSDE or use Bacup/Restore to local MSDE and the same coming back to the
> office. Is one better/safer/less error prone then the other? Can I attach a
> DB if it was never detached/ can I restore a DB to server that was not the
> one it was backed up on?
> 2. The MasterDB will have to be replicated to local MSDE when a user puts a
> deal in-transit. When the user is back in the office all changes to the
> local(MSDE)MasterDB will need to be replicated back to the network version.
> While the DealDB will simply be either attached or restored back to the
> network.
> I guess I would use merge replication for the MasterDb? Going to local would
> I use Push or Pull subscription, and what about going back to network Push or
> Pull?
> Can someone help me out with the details, is there a script I can use?
> Thanks!
sql

replication sequence

I have 2 tables which tab B depends on the record on tab A. In publisher, records are generated to tabA before some audit information record to tabB. In subscriber, there is replication error that the trigger in tab B couldn't find the corresponding record in tab A and cause the transactional replication error. And I found the comand_id within the same xact_segno of record in tab B is smaller than that of record in tab A. Does it mean the data in tab B replicate before tab A?

Also, how to know the replication sequence to the subscriber?

Thanks in advance!

You may want to check your trigger to see which table is committing first. Transactional replication will replicate the commands/transaction in the order they were applied.

Replication Problem

When i tries to insert a record at publisher the record is get deleted in the
publisher instead of propagating to subscriber, this is not happening always.
I am using two way merge replication
Thanks
Kailux
It probably happens because of the conflict. Do you see any conflicts
occuring during synch?
MC
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:3D3E1D37-34D4-4C5E-A2AF-1AF2E22FF8A8@.microsoft.com...
> When i tries to insert a record at publisher the record is get deleted in
> the
> publisher instead of propagating to subscriber, this is not happening
> always.
> I am using two way merge replication
> Thanks
> Kailux

Replication Problem

When i tries to insert a record at publisher the record is get deleted in th
e
publisher instead of propagating to subscriber, this is not happening always
.
I am using two way merge replication
Thanks
KailuxIt probably happens because of the conflict. Do you see any conflicts
occuring during synch?
MC
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:3D3E1D37-34D4-4C5E-A2AF-1AF2E22FF8A8@.microsoft.com...
> When i tries to insert a record at publisher the record is get deleted in
> the
> publisher instead of propagating to subscriber, this is not happening
> always.
> I am using two way merge replication
> Thanks
> Kailux

Replication Problem

When i tries to insert a record at publisher the record is get deleted in the
publisher instead of propagating to subscriber, this is not happening always.
I am using two way merge replication
Thanks
KailuxIt probably happens because of the conflict. Do you see any conflicts
occuring during synch?
MC
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:3D3E1D37-34D4-4C5E-A2AF-1AF2E22FF8A8@.microsoft.com...
> When i tries to insert a record at publisher the record is get deleted in
> the
> publisher instead of propagating to subscriber, this is not happening
> always.
> I am using two way merge replication
> Thanks
> Kailux

Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison

Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison

Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison