CODEWITHSUNDEEP
.netsql-serverdatabaseentity-frameworkado.net
rob
rob

Reputation: 227

Export SQL Server Database to Access using entity framework

Is it possible to export a sql server database (2008) to a new access database using the Entity framework (or anything else for that matter in code)?

I have developed a desktop facing application that connects to a sql sever on a server and my client wants to be able to take snapshots of the database in access to send to people who don't have sql or access to the sql server (as they can't do it manually).

This is being done in c# .NET 3.5 SP1

Thanks

Upvotes: 2

Views: 648

Answers (1)

Sheng Jiang 蒋晟
Sheng Jiang 蒋晟

Reputation: 15271

It would be much easier if you can convince the user to use SQL CE instead. You should be able to create an adp database to use as the front end of the SQL CE database. You can use Microsoft Sync Framework to sync data between databases.

Upvotes: 1

Related Questions