What happened to the Generate Scripts Wizard in SSMS 2014

Hi,

What happened to the Generate Scripts option in SSMS 2014?  In prior versions you were able to right click on a database and click Generate Scripts, choose the table and select "Include Data".  I think it's been moved in 2014 but don't know where.

I need to script a table with data.

Thanks in advance!

Bill
LVL 14
Bill RossAsked:
Who is Participating?
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.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
This explains where it is.
https://msdn.microsoft.com/en-us/library/hh245282.aspx

it's called "Generate and Publish Scripts Wizard"
https://msdn.microsoft.com/en-us/library/bb895179.aspx

Regards Marten
0
Bill RossAuthor Commented:
Hi,

This doesn't seem to have the include data option...

Thanks,

Bill
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
No it has, it's like before.
Schema only
Schema and data
Data only
Look and you will find it!
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
under "Advanced Scripting Options Page"
there is quote:
"Types of data to script - Selects what should be scripted: Data only, Schema only, or both. The default is Schema only"
Quote is from: https://msdn.microsoft.com/en-us/library/bb895179.aspx#AdvScriptOpt

Regards Marten
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
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

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.