Generating SQL change scripts in SSMS 2008
- by Munish Goyal
I have gone through many related SO threads and got some basic info.
Already generated DB diagram.
After that i am unable to find a button/option to generate SQL scripts (create) for all the tables in diagram.
"Generate script" button is disabled, even on clicking the table in diagram.
However i enabled the auto-generate option in tools-designer. But what to do with previous diagrams.
I just want an easy way to auto-generate such scripts (create/alter) and would be gud if i get auto-generated stored procs for insert/selects/update etc.
EDIT: I could do generate scripts for DB objects.
Now:
1. How to import DB diagram from another DB.
2. How to generate (and manage their change integrated with VS source control) routine stored-procs like insert, update and select.
Ok let me ask another way, can experts guide on the usual flow of creating/altering tables (across releases), creating stored-procs (are stored-procs the best way to go ?) and their change-management using SSMS design tools and minimal effort ?