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
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
Microsoft SQL Server
Last Comment
Marten Rune
ASKER
Hi,
This doesn't seem to have the include data option...
Thanks,
Bill
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!
Schema only
Schema and data
Data only
Look and you will find it!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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