|
Home > Archive > MS SQLCE > August 2005 > Transfer data from SQL Server CE to SQL Server 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transfer data from SQL Server CE to SQL Server 2000
|
|
| Robert Lie 2005-08-11, 7:23 am |
| Dear All,
I've just developed an inventory module to store items in local database
of ppc. And i use sql server ce as the database of ppc.
Let's say I have a table named Item (barcode nvarchar(30), quantity
int) in sql server ce, and I have the Item table in my sql server 2000
as well.
How the simplest method to transfer the data stored in Item table of sql
server ce to Item table of sql server 2000?
Thanks
Robert Lie
| |
| Hilary Cotter 2005-08-11, 7:23 am |
| RDA.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Robert Lie" <robert.lie24@gmail.com> wrote in message
news:eT8gxBmnFHA.3020@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
> I've just developed an inventory module to store items in local database
> of ppc. And i use sql server ce as the database of ppc.
> Let's say I have a table named Item (barcode nvarchar(30), quantity
> int) in sql server ce, and I have the Item table in my sql server 2000
> as well.
>
> How the simplest method to transfer the data stored in Item table of sql
> server ce to Item table of sql server 2000?
>
> Thanks
>
> Robert Lie
| |
| Mario Aoun 2005-08-11, 1:26 pm |
| Hi Robert Lie,
Check the following sites for synchronization:
DataPort Wizard DPW.exe from http://www.primeworks.pt
and
RemoteSQLCE or SQLLinkCE from http://www.gui-innovations.com
also you can use RDA but it will require some coding from your side.
good luck
mario aoun
"Robert Lie" wrote:
> Dear All,
>
> I've just developed an inventory module to store items in local database
> of ppc. And i use sql server ce as the database of ppc.
> Let's say I have a table named Item (barcode nvarchar(30), quantity
> int) in sql server ce, and I have the Item table in my sql server 2000
> as well.
>
> How the simplest method to transfer the data stored in Item table of sql
> server ce to Item table of sql server 2000?
>
> Thanks
>
> Robert Lie
>
|
|
|
|
|