importing Database

[e-mid]

i want to import my database in sql server 2000 into sql server ce, in the
Pocket Pc 2002 emulator.
as far as i read, we need a pocket pc to use activeSync, but i am working
with emulator.
what should i do then?

and is there any restrictions when importing from sql server 2000 to sql
server ce..

 

[William Ryan eMVP]

You can still see the SQL Server from the Emulator. One easy way is to
mimic the schema of the tables. Call DataAdapter.Fill from the big sql
server but set its AcceptChangesDuringFill property to false. Once you have
a datatable filled, you can just have another adapter configured which
points to the CE database - you simply call Update at that point and if
everything is configured properly, the data should move itself. You may
also be interested in SSCEDirect
http://www.devbuzz.com/content/zinc_fitiri_sscedirect_pg1.asp by Fitiri.

HTH,

Bill

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[e-mid]

thknz William, that is helpful

You can still see the SQL Server from the Emulator. One easy way is to
mimic the schema of the tables. Call DataAdapter.Fill from the big sql
server but set its AcceptChangesDuringFill property to false. Once you have
a datatable filled, you can just have another adapter configured which
points to the CE database - you simply call Update at that point and if
everything is configured properly, the data should move itself. You may
also be interested in SSCEDirect
http://www.devbuzz.com/content/zinc_fitiri_sscedirect_pg1.asp by Fitiri.

HTH,

Bill

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[William Ryan eMVP]

Cool. here's an article I wrote on the full framework but the exact same
principal still applies -
http://www.knowdotnet.com/articles/datasetmerge.html - figured it might
help.

Let me know how it goes.

Cheers,

Bill

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups