Import into SQLServerCE

Discussion in 'microsoft.public.sqlserver.ce' started by Atley, Nov 12, 2003.

  1. Atley

    Atley Guest

    have an access database that contains data that i want to import into the
    SQLServerCE database on my WM2003 device. How the heck can I do that? I
    can't find a suitable answer anywhere in any documentation.

    Atley
     
    Atley, Nov 12, 2003
    #1
    1. Advertisements

  2. There is no integrated way to do this other than moving the data from
    access to SQL Server and then using SQL CE to copy it down from there.
    There is a third part tool discussed in the post below that offers what
    you're looking for:
    ---------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.

    --------------------
    | From: "Atley" <>
    | Subject: Import into SQLServerCE
    | Date: Wed, 12 Nov 2003 09:16:10 -0500
    | Lines: 7
    | X-Priority: 3
    | X-MSMail-Priority: Normal
    | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
    | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
    | Message-ID: <>
    | Newsgroups: microsoft.public.sqlserver.ce
    | NNTP-Posting-Host: dial-1-1-50.cybrnet.net 209.5.241.177
    | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
    | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:10117
    | X-Tomcat-NG: microsoft.public.sqlserver.ce
    |
    | have an access database that contains data that i want to import into the
    | SQLServerCE database on my WM2003 device. How the heck can I do that? I
    | can't find a suitable answer anywhere in any documentation.
    |
    | Atley
    |
    |
    |
     
    Brian Sabino [MS], Nov 12, 2003
    #2
    1. Advertisements

  3. Atley

    Atley Guest

    Is there any way to flat file my data and then get it into the SQLServerCE
    database?

    How would I get it from SQLServer 2000 to SQLServerCE?

    Atley


     
    Atley, Nov 13, 2003
    #3
  4. There is no bulk import support in SQL CE. You could send your data down
    in some format you understand, and then insert the data using parameterized
    insert statements.
    For information on moving data from SQL Server to SQL Server CE check the
    Books Online for sections on Replication or Remote Data Access.

    ---------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.

    --------------------
    | From: "Atley" <>
    | References: <>
    <>
    | Subject: Re: Import into SQLServerCE
    | Date: Wed, 12 Nov 2003 21:41:32 -0500
    | Lines: 61
    | X-Priority: 3
    | X-MSMail-Priority: Normal
    | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
    | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
    | Message-ID: <e7CTs#>
    | Newsgroups: microsoft.public.sqlserver.ce
    | NNTP-Posting-Host: dial-2-24.cybrnet.net 209.5.206.102
    | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
    | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:10139
    | X-Tomcat-NG: microsoft.public.sqlserver.ce
    |
    | Is there any way to flat file my data and then get it into the SQLServerCE
    | database?
    |
    | How would I get it from SQLServer 2000 to SQLServerCE?
    |
    | Atley
    |
    |
    | | > There is no integrated way to do this other than moving the data from
    | > access to SQL Server and then using SQL CE to copy it down from there.
    | > There is a third part tool discussed in the post below that offers what
    | > you're looking for:
    | >
    | > >From: "bumerang" <>
    | > >Subject: PocketSYNC MSDE,MSSQL beta version avaliable
    | > >
    | > >Hello,
    | > >
    | > >PocketSYNC import/export utility for SQLCE 2.0, now MSDE,MSSQL beta
    | version
    | > >avaliable you dont need IIS or any extra settings (just MDAC for MSSQL
    | > >access).
    | > >
    | > > You can download demo version from
    http://www.efeyazilim.com/pocketsync
    | > >
    | >
    | > ---------------------
    | > This posting is provided "AS IS" with no warranties, and confers no
    | rights.
    | >
    | > --------------------
    | > | From: "Atley" <>
    | > | Subject: Import into SQLServerCE
    | > | Date: Wed, 12 Nov 2003 09:16:10 -0500
    | > | Lines: 7
    | > | X-Priority: 3
    | > | X-MSMail-Priority: Normal
    | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
    | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
    | > | Message-ID: <>
    | > | Newsgroups: microsoft.public.sqlserver.ce
    | > | NNTP-Posting-Host: dial-1-1-50.cybrnet.net 209.5.241.177
    | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
    | > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:10117
    | > | X-Tomcat-NG: microsoft.public.sqlserver.ce
    | > |
    | > | have an access database that contains data that i want to import into
    | the
    | > | SQLServerCE database on my WM2003 device. How the heck can I do that?
    | I
    | > | can't find a suitable answer anywhere in any documentation.
    | > |
    | > | Atley
    | > |
    | > |
    | > |
    | >
    |
    |
    |
     
    Brian Sabino [MS], Nov 13, 2003
    #4
  5. Atley

    Alan Guest

    we might have a solution for you... we're actually in beta testing now
    and our initial tests for inserting 10,000 records ranged from 15
    seconds to 18 seconds. Unlike other loaders our tool lets you insert
    data from anywhere even a web service, unlike others which restrict
    you to Access or SQL server ....

    If you want more information about the tool, please go to
    http://www.fitiri.com/F_Wireless_Apps2.html

    email me and I set you up as a tester ...
     
    Alan, Nov 18, 2003
    #5
  6. Atley

    Alan Stewart Guest

    Since we've noticed that there are a lot of issues regarding Bulk
    Inserts into the CF, we've developed a SQL CE Bulk Insert tool named
    SSCEDirect. We're currently looking for Beta Testers.

    Our initial tests for inserting 10,000 records ranged from 15 seconds
    to 18 seconds. Unlike other loaders our tool lets you insert data from
    anywhere even a web service, unlike others which restrict you to
    Access or SQL server ....

    If you want more information about the tool, please go to
    http://www.fitiri.com/F_Wireless_Apps2.html.

    If you're interested or if you have an questions please feel free to
    email me a_stewart_at_fitiri_dot_com (remove underscores and make
    appropriate changes).

    PS. I had to remove the earlier posting and repost without my email
    address, I was inundated with spam. Apologize for any confusion or
    inconvenience

    Alan Stewart
    www.fitiri.com
     
    Alan Stewart, Nov 20, 2003
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.