Francisco Tapia
fhtapia at gmail.com
Tue Jun 19 08:37:48 CDT 2012
Gustav, I haven't worked on replication in a long time but I had a project several years ago that made use of replication, in Sql Express there are no Sql Agents (that I'm aware of) and thus you'll need to run the pull subscription to your express db via programming check out this MS link to get you on your way... http://msdn.microsoft.com/en-us/library/ms147314%28v=sql.100%29.aspx -Francisco http://bit.ly/sqlthis | Tsql and More... Let Apple know you want turn by turn on your iPhone 4! https://plus.google.com/112803888444646122406/posts/HmQej9pHZQM <http://db.tt/JeXURAx> On Thu, Jun 14, 2012 at 11:49 PM, Gustav Brock <gustav at cactus.dk> wrote: > Hi all > > Our client asks for an option to replicate data between the central > database and a local database on the user's laptop where an Access 2010 app > is the frontend. > > The users are travelling purchasers, and the requirement is an option to > hook up the laptop in the morning while at the hotel and sync, visit the > suppliers where the laptop may be off-line, and return in the evening > syncing again. They travel all over the World, so "morning" and "evening" > are local times, thus I cannot count on "windows" or quiet hours. > > As the central database is SQL Server 2008 and the database size is well > within the limits of SQL Server Express, my first thought was to install a > local copy of SQL Server Express and set up replication between the central > server and these local servers. > > But I haven't dealt with replication and SQL Server before, so I wonder if > this is as simple as it sounds? Is this a no-brainer (just look up the BOL, > as JC would say (not)), or are there any pitfalls, tips, or perhaps better > methods? > > /gustav > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >