Hi
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>> John,
>> yes - this can work. You'd have a merge publication and pull
>> subscriptions, activated by your vb.net application.
>> Cheers,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>
2012年3月19日星期一
Disconnected application and replication
标签:
application,
backend,
database,
disconnect,
disconnected,
laptop,
microsoft,
mysql,
oracle,
replication,
server,
situation,
sql,
users
订阅:
博文评论 (Atom)
没有评论:
发表评论