The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi, is there anyway i can do the following?

For an application on windows mobile 6.5 using ultralite as the db, am I able to : 1) press button 1 --> send tables 1, 2, 3 for sync-ing with SQL server 2) press button 2 --> send tables 4, 5, 6 for sync-ing with SQL server

Thanks!

asked 28 Jul '10, 02:17

Vox's gravatar image

Vox
21112
accept rate: 0%

edited 15 Mar '13, 20:52

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262


Our UL expert has the following suggestion:


One way that this can be done is by creating a couple of publications. For example, execute the following SQL statements on the UltraLite database:

CREATE PUBLICATION P1 (TABLE T1, TABLE T2, TABLE T3 )
CREATE PUBLICATION P2 (TABLE T4, TABLE T5, TABLE T6 )
CREATE SYNCHRONIZATION PROFILE S1
    'Publications=P1;MobiLinkUID=user;stream=tcpip(host=acme.com);ScriptVersion=test'
CREATE SYNCHRONIZATION PROFILE S2
    'Publications=P2;MobiLinkUID=user;stream=tcpip(host=acme.com);ScriptVersion=test'

Then, when button 1 is clicked, execute this SQL statement:

SYNCHRONIZE PROFILE S1

And when button 2 is clicked, execute this SQL statement:

SYNCHRONIZE PROFILE S2
permanent link

answered 28 Jul '10, 15:11

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

edited 28 Jul '10, 15:45

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×265
×128
×66
×46
×25

question asked: 28 Jul '10, 02:17

question was seen: 1,621 times

last updated: 15 Mar '13, 20:52