| Author |
Topic |
|
morphviper
Yak Posting Veteran
60 Posts |
 Posted - 2008-07-17 : 10:32:18
|
| here is my challenge.I have mobile computers that are used away from any internet or networking connections. These computers use sql 2005 express to hold data collected by the users in the field.I need to come up with a solution that when they do connect to the internet or network that the data would be automatically pushed or pulled to the server and visa versa. The server is using Sql server 2005 express for the proof of concept.I need to pull data from one or two table from the mobile devices and then clean the mobile device of this data.from the server I need to send data from several tables to the mobile device tables.I was looking into Service Broker, but am having trouble figuring out how to use service broker and even if it is a good solution.Any assistance or suggestions are greatly appreciated! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-17 : 13:00:23
|
| for service broker to work one of your servers (the central one probably) must not be express edition.service broker would work for this... but you'd have to prevent poison messages from occuring when you don't have a connection on both client and server end.maybe replication would be a better option... but i'm not sure about this because i don't have much experience with it._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
morphviper
Yak Posting Veteran
60 Posts |
Posted - 2008-07-17 : 13:18:54
|
| thanks for the suggestion butI just talked to management and I guess we will be using Express on the mobile and the server.So... from my research, I will have to write my own code to do what I need.if anyone has an opinion about this, let me know..Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-17 : 13:25:38
|
then look into replication. it might work...  _______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 15:35:57
|
| You wanna go either with Merge replication or transactional replication. |
|
|
|
morphviper
Yak Posting Veteran
60 Posts |
Posted - 2008-07-18 : 10:07:44
|
| You can do replication with Express on both ends?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 10:25:25
|
quote:
Originally posted by morphviper
You can do replication with Express on both ends??
Only with Merge replication. |
|
|
|
morphviper
Yak Posting Veteran
60 Posts |
Posted - 2008-07-18 : 10:46:08
|
| I am doing google searches with little luck. any links you could pass me would be helpful. Everything I am finding requires a 2005 server.thanks, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-19 : 00:23:12
|
| How about linked server? |
|
|
|
peter2008
Starting Member
3 Posts |
Posted - 2008-10-14 : 03:46:39
|
| SQL Service Broker is a powerful asynchronous queuing and messaging infrastructure available in all editions of SQL Server 2005. Another one is Full-Service Broker A broker that provides a large variety of services to its clients.________________________________________________________________________[url=http://www.digitaltransitions.com]Capture One[/url] [url=http://www.nationaltransportllc.com]Auto Transport[/url] |
|
|
|
|
is Service Broker a good Solution