《SQL Anywhere Studio 9开发指南》代码

ninetailsfox

7.4.4 The DBMLSYNC Command Line [Top]
-----------------------------------------------------------------------------------
"%ASANY9%\win32\dbmlsync.exe" -c "DSN=remo" -o c:\temp\dbmlsync.txt -vnosu -x
-----------------------------------------------------------------------------------
ls_address = 'host=localhost'
li_RC = Run ( '"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbmlsync.exe" ' &
   + '-ap "test1,test2" -c "DSN=remo" -e adr=~'' &
   + ls_address &
   + '~' -k -o c:\temp\dbmlsync.txt -vnorsu -x' )
-----------------------------------------------------------------------------------
intRC = CreateProcess("\windows\dbmlsync.exe", "-c ""dsn=handheld"" -e adr='" _
    & strHost _
    & "';sa='OFF' -d -k -o \Temp\dbmlsync.txt -pd dbsock9.dll -vnosu -x", _
    0, 0, 0, 0, 0, 0, 0, 0)
-----------------------------------------------------------------------------------
SET @address = 'host=localhost';
CALL xp_cmdshell ( STRING (
   '"%ASANY9%\win32\dbmlsync.exe" -ap "test1,test2" -c "DSN=remo"  -e adr=''',
   @address,
   ''' -k -o c:\temp\dbmlsync.txt -vnosu -x' ) );
-----------------------------------------------------------------------------------

ninetailsfox

7.4.5 SYSSYNC and Publication Defaults [Top]
-----------------------------------------------------------------------------------
CREATE TABLE SYS.SYSSYNC (
   sync_id            UNSIGNED INT NOT NULL,
   type               CHAR ( 1 ) NOT NULL, -- 'D' for MobiLink
   publication_id     UNSIGNED INT NULL,   -- points to SYSPUBLICATON
   progress           NUMERIC ( 20 ) NULL,
   site_name          CHAR ( 128 ) NULL,   -- MobiLink user name
   "option"           LONG VARCHAR NULL,   -- OPTION clause
   server_connect     LONG VARCHAR NULL,   -- ADDRESS clause
   server_conn_type   LONG VARCHAR NULL,   -- TYPE clause
   last_download_time TIMESTAMP NULL,
   last_upload_time   TIMESTAMP NOT NULL DEFAULT 'jan-1-1900',
   created            NUMERIC ( 20 ) NULL,
   log_sent           NUMERIC ( 20 ) NULL,
   generation_number  INTEGER NOT NULL DEFAULT 0,
   extended_state     VARCHAR ( 1024 ) NOT NULL DEFAULT '',
   PRIMARY KEY ( sync_id ) );
-----------------------------------------------------------------------------------
CREATE SYNCHRONIZATION SUBSCRIPTION TO p1
   TYPE tcpip
   ADDRESS 'host=localhost'
   OPTION ConflictRetries='2';
-----------------------------------------------------------------------------------

ninetailsfox

up

jianghuilei

up

wenshaohan

up