I've found a few articles & discussions on how to import data from Access to SQL Server or SQL Server Express, but not to SQL Server CE. I can access both the the Access data and CE data in the VS database explorer with seperate connections, but don't know how to move the data from one to the other. (I'm using c#.) Any suggestions? Thanks.
+1
A:
You can do it using SSIS, or even in SQL Server Explorer if you are not looking to do it programmatically.
Christopher Edwards
2009-01-26 23:00:36
I'd echo ctacke's answer. There's not an easy point-and-click way of doing it with Visual Studio. If you don't want to use PrimeWorks, the answer is too deep to discuss here. As Christopher Edwards pointed out, SSIS can do it, but learning that is an undertaking.
Brent Ozar
2009-01-27 12:05:07
The DataPorrWizard worked as advertised. Thanks.
pro3carp3
2009-01-27 21:24:46
A:
you can also use the the "sql server migration wizard" to convert it to sql server database and the use this tool to convert it back to a .sdf database
Johnny Blaze
2009-02-05 18:32:31