importing Database

  • Thread starter Thread starter e-mid
  • Start date Start date
E

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..
 
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
 
thknz William, that is helpful

William Ryan eMVP said:
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
Click to expand...
 
Back
Top