Generate Script From Sql Server DataBase With Data :
Step 1 : Select DataBase Right Click -- > Generate Scripts
-- > Next
-- > Next
Step 2 : Select DataBase
Step 3 : Table/View Options -- - > ScriptData == > True - > Next
(True Select With Data's are Script)
Step 5 : Select Stored Procedure's -- > Next
(Select Stored Procedure's,Cursor,UserDefined Function Etc....)
Step 6 : Select Script to New Query Window -- > Next
Script Stored Procedure's ....
(script Stored Procedure's)
(True Select With Data's are Script)
Step 4 : Select Table's -- > Next
(Select Table's)
(Select Table's)
Step 5 : Select Stored Procedure's -- > Next
(Select Stored Procedure's,Cursor,UserDefined Function Etc....)
Step 7: Finish Click ..
Script Tables Use First Table Insert Queries and With Data ...
(and Mutiple Table Use all Table)
(script Stored Procedure's)
No comments:
Post a Comment