467,923 Members | 1,436 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

Export from MSDE

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
  • viewed: 4609
Share:
1 Reply
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.

Similar topics

1 post views Thread by izzy | last post: by
10 posts views Thread by noname | last post: by
3 posts views Thread by *no spam* | last post: by
4 posts views Thread by Anthony P. Mancini | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.