Post reply

import table and data in compact edition

  • June 26, 2007 at 1:53 pm

    #179235

    Guys,

    Is there anyway we can import data into sql server 2005 compact edition.

    Any inputs/suggestions would help

    Thanks

  • June 26, 2007 at 2:03 pm

    #715332

    Never done anything like this before so I'm just throwing ideas out there.

     

    - BCP IN

    - Linked server to text file

    - Make a small app (vba, vbs) that inserts line by line (slowest option).

  • June 27, 2007 at 12:22 am

    #715434

    You can use Remote Data Access(RDA) or Merge Replication.

    Go through the below link for details.

    http://msdn2.microsoft.com/en-us/sql/bb219480.aspx

  • July 3, 2007 at 5:00 am

    #716826

    Thanks for your reply.

    When I am trying to import data using merge replication I am getting 'charecter set' incompatibility error - the schema file for

    the table created in SQL Server 2005 does seem to run in SQL Server CE edition. Is there any way round it since the syntax for

    SQL CE and SQL Server 2005 is different.

    I get the following error message

    "A call to the sql server reconciler failed try to resynchronise.

    Schema script cannot be propagated to the subscriber

    The merge process was unable to deliver the snapshot to the subscriber. If using web synchronization the merge process may have

    been unable to create or write to the message fil. When troubleshooting, restart the synchronization with verbose history logging

    and specify an output file to which to write.

    "

    Any suggestions and inputs would help

    Thanks

  • July 3, 2007 at 9:18 pm

    #717045

    You may want to try getting the data to a desktop version as it is a bit easier to work with to test that everything is all up & running OK.

    I found the tutorials here really good for getting Web Synchronisation & IIS - as well as access the data on the mobile once there:

    http://msdn2.microsoft.com/en-us/library/bb226707.aspx

    remote data access examples:

    http://msdn2.microsoft.com/en-us/library/bb226708.aspx

     

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

  • October 22, 2007 at 1:00 pm

    #744216

    I have the same problem. The tutorials said to open the SQL Server Business Intelligence Development Studio, which to me looks like Visual 2005. There, you need to create a project to do just a table import or bring in data from a spreadsheet. After spinning my wheels for a couple of hours, I found the explanation that you cannot do this in SQL Express (and I believe the developers version also). It's not like 2000, where you just right-click and select All tasks 'import data'. BTW I am not a programmer - yet.

  • October 23, 2007 at 7:54 am

    #744543

    I found a way to copy a spreadsheet into 2005 Express by using the DTS Wizard. It's located in:

    Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard

    It's pretty straight-forward. I need to figure out how to access it through the SQL Server Management Studio page. It's a learning experience since we still can not use it at work. I assume the full-blown SQL 2005 Enterprise has everything set up for you. But, for now, this will work for my imports.

  • May 21, 2008 at 7:07 am

    #818535

    I found this wonderful program on the CodeProject site that solves this problem and works quite well to copy tables from SQL Server 2005 Express to a SQL Server Compact Edition Database:

    http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx?display=Print

    Beware that when you compile it, there will be a warning that it cannot find some files. Just acknowledge and let it continue and the program will work. I haven't found the time to troubleshoot the missing files yet so, if someone else does, please let us know here. I just know that it worked "as-is" to copy my Express DB to Compact DB.

    Incidently, Code Project is another great developer resource just as SQLServerCentral is. I have found that by using both of these sites, I can find solutions to most of my development questions; whether SQL Server or general programming related. 🙂

  • May 25, 2008 at 9:46 pm

    #820095

    Hi , this utility will help you importing data from sqlserver ,access,excel ,mysql to Sqlce.

    http://sourceforge.net/projects/sqlceviewer/

  • May 20, 2009 at 8:26 am

    #997629

    I have use the tool recommended from Johnny Cant but I'm getting an error when I try to open the connection in VS2008.

    The selected database was created with an earlier version of SQL Server Compact and needs to be upgraded to SQL Server Compact 3.5 before the connection can be opened or tested. Upgrade the database by creating a new data connection and completing the Add Connection dialog box.

    I selected CE3.5 in the tool for the destination file. Now What I can't find is a way to go back and chack the path to where it's pointing to for the .dll.

    Any ideas?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply