Mass SQL export

[bouwob]

I come from a background of using mysql and phpadmin. In phpadmin you have the ability to export your data in sql format including tables, SP's, functions, data, etc.

Is there a way for me to do this in MS SQL server management studio?

I can export the database but the only option it seems to give me is CSV, which wont work all that well with sp's or table structures.

tia

 

[AlexCuse]

If you right click an object you get options for scripting. For table structures, script as --> create to --> whatever ought to do what you need.

Hope this helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[bouwob]

This allows me to script a single table or SP, but does not allow me to get everything at once. I have about 35 tables and over 100 SP's that will need to come out this way and it will take most of the day to do it 1 by 1.

Is there any better solution for getting everything at once?

 

[PatriciaObreja]

The scripting will do all the objects that you select in the first tab "General": tables, stored procedures etc.

Another method would be to backup entire database, and restore it where you want.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium