June 11, 2011 at 5:53 pm
Is there a way to quickly generate schema script for an existing database?
June 11, 2011 at 9:46 pm
Hi,
Just do these steps:
1-right-Click on database name on your object explorer
2- select "script database as"
3- select "Create To"
4- choose where do you want to generate your script.
Cheers
Ashkan
Best Regards,
Ashkan
June 12, 2011 at 4:57 am
And if you go to Tools -> Options -> SQL Server Object Explorer -> Scripting, you can exercise some control over how scripts are generated.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2011 at 5:02 am
Thanks Grant Fritchey , I didn't know that;)
Best Regards,
Ashkan
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply