July 22, 2010 at 12:22 am
I am using SQL SErver 2005 express edition. Is there any tool available for free which can generate the scripts for database objects- tables ,sps , functions including table data,primary keys and foreign keys relationship and every other type of keys.
July 22, 2010 at 1:38 am
gaurav-404321 (7/22/2010)
I am using SQL SErver 2005 express edition. Is there any tool available for free which can generate the scripts for database objects- tables ,sps , functions including table data,primary keys and foreign keys relationship and every other type of keys.
Yes, SSMS.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 1:56 am
can u plz guide step by step how to do that
July 22, 2010 at 2:57 am
gaurav-404321 (7/22/2010)
can u plz guide step by step how to do that
Right click the object, select Script Database/Table/etc -> Create to (select your wanted option)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 2:59 am
I want to generate the script for all tables in one go not for one by one table
Also i want to generate the insert script for table data rows .
July 22, 2010 at 3:01 am
gaurav-404321 (7/22/2010)
I want to generate the script for all tables in one go not for one by one tableAlso i want to generate the insert script for table data rows .
Right click on you database, select "Tasks", then "Generate Scripts"..and follow the wizard
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 3:10 am
There is a wizard which will accomplish your task
Right click on the database, select script database as and then select either create, drop or drop and create option.
December 6, 2010 at 11:01 pm
If you want to script data, you'll need to explicitly set the option. Under the "Choose Script Options" dialog, scroll down, you'll see the "Script Data" option under the Table/View Options section
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply