Monday 3 June 2013

Generate Script From Sql Server DataBase With Data

Generate Script From Sql Server DataBase With Data :

Step 1 :    Select DataBase Right Click  -- >  Generate Scripts  
               
                 -- > Next




Step 2 :   Select DataBase 


Step 3 :   Table/View Options  -- - >  ScriptData == >  True - >  Next
            (True Select With Data's are Script)



Step 4 :    Select Table's  -- >  Next 
                               (Select Table's)

                 

Step 5 :   Select Stored Procedure's  -- >  Next 
                               (Select Stored Procedure's,Cursor,UserDefined Function Etc....)




Step 6 :   Select Script to New Query Window  -- >  Next 




Step 7:   Finish Click ..


     Script Tables Use First Table Insert Queries and With Data ...
        (and Mutiple Table Use all Table)



      Script Stored Procedure's ....

        (script Stored Procedure's)




                              













No comments:

Post a Comment