|
|
 FAQ
 Search
 Memberlist
 Usergroups
 Register
 Profile
 Private messages
 Log in
|
|
| Author |
Message |
John
Guest
|
 Posted: Thu Apr 20, 2006 7:56 am Post subject: Disconnected application and replication |
 |
|
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
Regards |
|
| Back to top |
|
 |
|
|
Paul Ibison
Guest
|
| Posted: Thu Apr 20, 2006 12:21 pm Post subject: Re: Disconnected application and replication |
|
|
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) |
|
| Back to top |
|
|
Hilary Cotter
Guest
|
| Posted: Thu Apr 20, 2006 2:31 pm Post subject: Re: Disconnected application and replication |
|
|
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...
|
|
| Back to top |
|
|
John
Guest
|
| Posted: Thu Apr 20, 2006 5:11 pm Post subject: Re: Disconnected application and replication |
|
|
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...
|
|
| Back to top |
|
|
Hilary Cotter
Guest
|
| Posted: Thu Apr 20, 2006 5:36 pm Post subject: Re: Disconnected application and replication |
|
|
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...
| Quote: | 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)
|
|
|
| Back to top |
|
|
|
|
