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.
From stackoverflow
-
You can do it using SSIS, or even in SQL Server Explorer if you are not looking to do it programmatically.
-
You might look at PrimeWorks' DataPort Wizard.
Brent Ozar : 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.pro3carp3 : The DataPorrWizard worked as advertised. Thanks. -
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
0 comments:
Post a Comment