[Mobilink] How to create the database programmattically instead of copying it manually to the device

[Former Member]

I'm trying to use Mobilink 12 to sync between SQL Server 2005 Database (as consolidated database) and a remote ultralite database on a windows mobile device, so i've done the following :

1. Created a new mobilink project having the Sql Server 2005 odbc connection as a consolidated database
2. Created a new sync model assigned the consolidated db to it -> choosed tables to include in the sync model -> created a publication "test" and a version "test
3. Deploy the sync model -> i choose "new ultralite database" as the type of the remote database -> i check the option of "Create a remote ultralite database"

Now I copy the created ultralite db to my windows mobile device ,run the mobilink server and start writing the client test application as the following:

1. I create a new windows mobile project and I write the following in the form load

   String ConnString = "dbf=\\Program Files\\smartdeviceproject1\\test.udb";

   Conn = new ULConnection(ConnString);

   Conn.Open();

   Conn.DatabaseID = 1;
   

2. I added a button for the sync process to the form and added the following code to the button click event:

   Conn.SyncParms.Publications = "test";

   Conn.SyncParms.StreamParms = "";

   Conn.SyncParms.UserName = "test";

   Conn.SyncParms.Password = "test";

   Conn.SyncParms.Version = "test";

   Conn.SyncParms.Stream = ULStreamType.TCPIP;

   Conn.Synchronize();

And it's running perfectly , my question is Is there anyway to create the database programmatically instead of copying it manually to the device?

[chris_keating · Accepted solution]

You will need to start the ML server with the -ftr switch which points to the location where the transfer files can be found. You can also have different files for different users by setting up unique folders.

A simple implementation in UL.Net is

    ULFileTransfer transfer = new ULFileTransfer();
    transfer.UserName = "u";
    transfer.Version = "v";
    transfer.Stream = ULStreamType.TCPIP;
    transfer.FileName = "MLFileTransfer.udb";
    transfer.LocalFileName = "MLFileTransferReceived.udb";
    string[] parms = new string[1];
    parms[0] = "You need to supply something";
    transfer.AuthenticationParms = parms;

    transfer.DownloadFile();
    transfer = null;
    System.Console.WriteLine("File transfer complete. ");