Webboy2008
asked on
Sql server 2008 R2
I have some tables that have data there. My plan is to have one .sql to do the following:
1. The script will have create table code and all of the data in the table will be in the script as well.
for example. I have table customer and have column first name, last name with data John Smith.
I want to get script from sql server 2008. Included the table structure and the data into one script. Does it seem possible?
Thanks,
1. The script will have create table code and all of the data in the table will be in the script as well.
for example. I have table customer and have column first name, last name with data John Smith.
I want to get script from sql server 2008. Included the table structure and the data into one script. Does it seem possible?
Thanks,
Yes, see http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx
ASKER
How about sql server 2005.?
ASKER
And I tried my sql server 2008. I don't see the option there.
>>How about sql server 2005.? <<
"Script Data option is new with Microsoft SQL Server 2008"
>>And I tried my sql server 2008. I don't see the option there.<<
Are you using the Express Edition?
"Script Data option is new with Microsoft SQL Server 2008"
>>And I tried my sql server 2008. I don't see the option there.<<
Are you using the Express Edition?
ASKER
It is Sql 2008 Server. Not express
Ok. So what option is not there?
ASKER
Script Data = True is not there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.