Link to home
Create AccountLog in
Avatar of Bill Ross
Bill RossFlag for United States of America

asked on

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
Avatar of Marten Rune
Marten Rune
Flag of Sweden image

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
Avatar of Bill Ross

ASKER

Hi,

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

Thanks,

Bill
No it has, it's like before.
Schema only
Schema and data
Data only
Look and you will find it!
ASKER CERTIFIED SOLUTION
Avatar of Marten Rune
Marten Rune
Flag of Sweden image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer