Importing Data to .sdf file

[Tamer Hesham]

I am using the SQL server 2005 enterprise edition, and VS.net 2005 CF 2.0,
i have an Access database file (.mdb) and i just want to create a new sql
mobile database file (.sdf) and to import the data inside the access file to
the sql mobile database, but i cant find how to import (DTS) !! but in
microsoft site about sql mobile 2005 they said that DTS is supported and
users can import/export data from/to more than databases like access and
oracle.
so any one can help me i will be glad.
thanks in advance
Regards

[Darren Shaffer]

to move data from Access to SQL Mobile, your best choice would be to
use JP's outstanding tool DesktopSQLCE at
http://www.primeworks.pt/

DTS is possible but will take you longer to figure out than to use this
approach.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Tamer Hesham" <Tamer...@discussions.microsoft.com> wrote in message
news:630AA9B1-3694-4444...@microsoft.com...

[Tamer Hesham]

So, please if you know the steps of how use the DTS from SQL Server Mangement
Studio to import data from access file to .sdf file, please let me know.
And for the desktopsqlce i cant find the download in http://www.primeworks.pt/
Thanks in advance

[Darren Shaffer]

http://www.primeworks.pt/Products/DataPortWizard.html

--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Tamer Hesham" <Tamer...@discussions.microsoft.com> wrote in message

news:41C50B04-6F29-48D5...@microsoft.com...