Bill Ross
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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