Export Data From MS SQL in INSERT INTO format

Hello,

I have a database running in MS SQL Server 2008 Express Edition.

My client has asked for a copy of the data in SQL CREATE TABLE and INSERT INTO format, rather than a raw backup.

I cant figure out how to do this from the management console.

Any help would be appreciated.
Kind Regards
Dan
LVL 5
DanJournoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kapil_GoyalCommented:
Hello

Just generate the script from Generate Script with script with data.
Just right click on the database >> Tasks >> Generate Script

Do remember to set the option "Script with data" yes.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Om PrakashCommented:
SELECT Database
right click
select Tasks
select generate scripts
this will open a wizard
You can select the tables, SPs, function you need to create script.
0
carsRSTCommented:
If i'm understanding you, try these steps.

1.  Get the table structure.  
     a.  Right click the table you want to backup and do following steps.
     b.  Script table as-->create to-->New Query Editor window
2.  in this output script, change the table name after "CREATE TABLE" to what ever you want to name it.
3.  On that same output script, add this at the bottom.
     "insert into [destination table] select * from [source table]

NOTE: if you are going to run multiple times, you will need to drop the table first before you run this script.

IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ' [destination table]') DROP TABLE [destination table]
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.