By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Export from MSDE

P: n/a
Hi everybody!

I am currently working with C# and MSDE. Is there an easy way to
export all the data from MSDE in case something crashes?
Also, is it possible to export the database structure?

Many thanks!

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
hi,
gd*****@deloitte.vg wrote:
Hi everybody!

I am currently working with C# and MSDE. Is there an easy way to
export all the data from MSDE in case something crashes?
Also, is it possible to export the database structure?

Many thanks!


for fast export you can resort on backup features offered by SQL Server....
in order to export data only, you have several choices, such as BCP out,
create INSERT INTO scripts opening a ADO.Net cursor, looping through each
table and writing to file... (or you can rely on MICROSOFT SQL Server MVP
Narayama Vyas Kondreddi master stored proc to generate INSERT INTO
statements you can find at
http://vyaskn.tripod.com/code/generate_inserts.txt )

as regard metadata and structure, you can use SQL-DMO object model to
perform this task, or have a look at free tools like
http://www.rac4sql.net/objectscriptr_main.asp )
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.