×

Discussion Board

Results 1 to 5 of 5
  1. #1
    Regular Contributor
    Join Date
    Dec 2008
    Location
    Suzhou, China
    Posts
    107

    Symbian DBMS - Porting application from Windows Mobile to Symbian

    Hi

    I'm busy porting an application from Windows Mobile to Symbian, but I'm having one major problem and hopefully a Symbian guru can advise me.

    I'm using Symbian DBMS for data storage where the Windows Mobile version uses SQL Compact. My problem is how to get the data from the SQL Compact database into a new Symbian DBMS database. Is there some tool available for this? I've tried exporting to SQL statements, modifying it and using dbshell to import it, but dbshell doesn't have internationalization support and my data is in Arabic. I would enter it manually, but it's several hundreds MBs of data.

    Surely somebody has written a utility for this or has a good technique?

    Regards

    Lionel

    P.s. The database only contains one table.

  2. #2
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: Symbian DBMS - Porting application from Windows Mobile to Symbian

    Sorry to say there are non for your requirement.

  3. #3
    Nokia Developer Champion
    Join Date
    Mar 2004
    Location
    Czech Republic
    Posts
    2,037

    Re: Symbian DBMS - Porting application from Windows Mobile to Symbian

    Hi,

    my advice would be:

    1/ Export the data from Windows Mobile databse file to some text format. I guess the XML would serve you well. As your data are arabic, be carefull about encoding and use e.g. UTF-8. For this you will probably need to program some simple method in your Windows Mobile code, i.e. do this export on your own directly under Pocket PC emulator.

    2/ Take the exported xml file, copy it into Symbian SDK and make another method, now under Symbian OS, which will take the file and insert the data in the Symbian DBMS file.

    So you have to program two methods, one for exporting on Windows Mobile and one for importing under Symbian OS.

    BR
    STeN

  4. #4
    Regular Contributor
    Join Date
    Dec 2008
    Location
    Suzhou, China
    Posts
    107

    Re: Symbian DBMS - Porting application from Windows Mobile to Symbian

    Thanks,

    Sounds good. Is anything special required in order to use UTF-8 in a Symbian DBMS? It shouldn't be too big an issue to do it via XML, surely a lot better than by hand.

    Regards

    Lionel

    Quote Originally Posted by stenlik View Post
    Hi,

    my advice would be:

    1/ Export the data from Windows Mobile databse file to some text format. I guess the XML would serve you well. As your data are arabic, be carefull about encoding and use e.g. UTF-8. For this you will probably need to program some simple method in your Windows Mobile code, i.e. do this export on your own directly under Pocket PC emulator.

    2/ Take the exported xml file, copy it into Symbian SDK and make another method, now under Symbian OS, which will take the file and insert the data in the Symbian DBMS file.

    So you have to program two methods, one for exporting on Windows Mobile and one for importing under Symbian OS.

    BR
    STeN

  5. #5
    Regular Contributor
    Join Date
    Dec 2008
    Location
    Suzhou, China
    Posts
    107

    Re: Symbian DBMS - Porting application from Windows Mobile to Symbian

    I've found this program that might be useful in case somebody else has a similar issue:

    http://www.codeproject.com/KB/databa...export_db.aspx

    I'm quite sure it either supports SQL Compact or I can make it support SQL Compact.

Similar Threads

  1. Replies: 3
    Last Post: 2008-09-09, 04:53
  2. Replies: 5
    Last Post: 2007-04-16, 08:57
  3. Replies: 3
    Last Post: 2006-09-28, 04:57
  4. Replies: 0
    Last Post: 2005-05-28, 10:20
  5. How to Access 9210 Dbms file from my desktop application?
    By Nokia_Archive in forum Symbian Networking & Messaging (Closed)
    Replies: 0
    Last Post: 2002-06-03, 03:46

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •