Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mass SQL export

Status
Not open for further replies.

bouwob

Programmer
Apr 12, 2006
171
US
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
 
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
 
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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top