Publish mdf database to provider automatically

[darylbewise]

Hello all,

I’m looking to be able to create a script of a .MDF database (data + schema) automatically using c# code.

What I want to be able to do is create a .sql file of all the data in a .mdf database (exactly what you can do using the “Publish to provider” tool in Visual Studio.

Any ideas on an easy way of achieving this?

 

[ca8msm]

Yes it's possible but you'll probably have to use the Access Object Library. I'd suggest asking in the relevant Access forum for tips on how to do it.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers