Export from MSDE

[gdubois]

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!

[Andrea Montanari]

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