Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2007-11-20 : 09:05:08
|
| Hi!I need to sync an application on windows mobile 5 that uses sql server mobile with sql server 2005. I've tried Merge and it populated the tables on the server with new fields and triggers. Does RDA do the same thing?Jesus saves. But Gretzky slaps in the rebound. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-20 : 09:08:30
|
RDA will create new columns on the WM side but not on the Server side.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2007-11-20 : 09:20:21
|
| Ah perfect, thanks! I'll definately set it up tomorrow. The application that runs on the server has a db layer which is autogenerated with an or mapper and we ran into problems with merge because of new fields being created.How is performance with RDA compared to writing your own webservice that handles sync operations? Today we have huge problems because the server sends all data as a big dataset (.net). WM have such small internal memory and sometimes the xmlfile (dataset) is too big for the device. I guess RDA solves this in a different way?Jesus saves. But Gretzky slaps in the rebound. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-20 : 09:28:59
|
Don't put your hope too high on RDA. I have not played with 2005 yet, but the prev version does have problem pulling large results down to WM. I remember trying to pull about 500K of records down on one occasion of testing and RDA fails.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2007-11-20 : 09:33:04
|
| Ok. I'll give a shot though. Merge did seem to work fine. I had an error in my filter which resulted in a db of 300 mb on the device. It took a couple of minutes but it worked and even replication after that.Jesus saves. But Gretzky slaps in the rebound. |
|
|
|
|
|
|
Does RDA create extra fields?