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.5k9129264


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.5k291441646

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:

×270
×130
×66
×47
×25

question asked: 28 Jul '10, 02:17

question was seen: 1,628 times

last updated: 15 Mar '13, 20:52