Last post Sep 14, 2015 09:33 AM by a2h
Sep 14, 2015 07:41 AM|Nadeem157|LINK
Is there any way to generate script for some tables in sql server 2005 with data. Please suggest
Sep 14, 2015 08:02 AM|eralper|LINK
In SQL Server 2008 there is a Generate Scripts Wizard which enables data professionals to
generate script for tables with data on SQL Server
But I'm not sure if it supports SQL Server 2005
Sep 14, 2015 08:04 AM|Nadeem157|LINK
So how to generate script in 2005 ?
Sep 14, 2015 08:11 AM|eralper|LINK
If you have an other version of SQL Serve Management Studio running you can connect to SQL Server 2005 instance and generate scripts for it.
If you connect, and follow Tasks > Generate Script... there is an advanced option where you can choose to script "Schema and data" using "Type of data to script" option
Sep 14, 2015 09:01 AM|Nadeem157|LINK
Thanks a lot Eralper
Sep 14, 2015 09:33 AM|A2H|LINK
generate script for some tables in sql server 2005 with data.
if you want to move data from one table to another with same schema then you can also use the Import and Export wizard of SQL Server to Export the data from one table to another table. You have the option to save the package using the wizard.
Please follow the below steps
You can get step by step explanation from this link : Run the SQL Server Import and Export Wizard