Skip to content
Aussieveedubbers

SQL Server 2005 Replication and Sync Question

0 likes
Share Share on Facebook Share on X Share on Reddit
Log in to reply

Brad Wolfsburg Elder

3,764 posts · joined Aug 2002 ·

#662767
Ok Internet Geeks ... I am in search of someone who "Actually" knows about and has worked with SQL Server 2005 and in particular Replication and Sync.

I am currently working on an applications that runs a SQL Server 2005 Back end with a Dot.Net (prim c# / asp.net) architecture up front. Anyway I am developing and "Unplugged" capability so a laptop can be unplugged from the network and operate offline for a period of time and will then resync when plugged back in. For obvious reasons I will need to replicate the current data within the SQL instance prior to unplug so that all relevant records are availible off line.

I am aware that SQL Server 2005 has a replication and sync ability but am looking for someone who has actually used it / set it up / lessons learnt.

If I am not happy with the level of protection it offers for over writes and orphans I will be looking at hitting the DB through custom objects and writting my own sync methods to work within the objects and offer protection and validation. I would preffr not to do this as I am a little short on time.

Any takers ? or Information ?
Brad
Why copy when you can own an original ?
Meyers Manx Australia

Gibbo Custom Title Time!

1,685 posts · joined Jun 2004 ·

#662773
I have a few contacts @ work, gimmie a day or so mate.

Trying to get hold of someone now.

Brad Wolfsburg Elder

3,764 posts · joined Aug 2002 ·

#662781
Gibbo wrote:I have a few contacts @ work, gimmie a day or so mate.

Trying to get hold of someone now.
Cool, no real rush I am away at the moment doing user needs stuff and have more than enough to keep me busy. Still keen to talk to people who actually do it.
Brad
Why copy when you can own an original ?
Meyers Manx Australia

555bug WRX Bug Boy

1,123 posts · joined Aug 2002 ·

#662787
Brad the ECM stuff i work with has a similar facility but they all cheat so to speak as if you want to work on a record then you check it out (lock the record) then the only person than can perform an update is the same user than locked the record. This way you don't run into issues with sync issues and rolling back transactions. If you truly have a requirement for replication with multi user transactions then I believe Oracle RAC is a much better choice but the DBA's out there will pipe up I'm sure

Brad Wolfsburg Elder

3,764 posts · joined Aug 2002 ·

#662793
555bug wrote:Brad the ECM stuff i work with has a similar facility but they all cheat so to speak as if you want to work on a record then you check it out (lock the record) then the only person than can perform an update is the same user than locked the record. This way you don't run into issues with sync issues and rolling back transactions. If you truly have a requirement for replication with multi user transactions then I believe Oracle RAC is a much better choice but the DBA's out there will pipe up I'm sure
mm yes and not really an issue. WIthin the local site no record locking needs to occur due to the DB design and the way in which the objects hit the DB. The front end takes care of record managment.

I am only concerned with being able to replicate say every 4 hrs from the disconnected instance to the main instance. The actual on site running of the DB GUI is already taken care of.

I can even go one step further and loc the DB at time of replication or use SubscriptionStreams to pick it up on the turn around.

The disconnected instance may just be one laptop being used without a connection at all and when it comes back say 2 weeks later I need to be able to bring the modified DB off it back onto the main instance.
Brad
Why copy when you can own an original ?
Meyers Manx Australia

Gibbo Custom Title Time!

1,685 posts · joined Jun 2004 ·

#662982
Sorry mate, no reply back from my guy yet, Im guessing it will be monday before I have some answers now. grrr

Gibbo Custom Title Time!

1,685 posts · joined Jun 2004 ·

#663329
Yeah, sorry mate, he hasnt done anything with replication on 2005 yet.

He did suggest you maybe look at SQL express for loading onto the laptop.