Sync-ing selective tables with MS SQL 2005

[Former Member]

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!

[Former Member]

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