SSMS Generate Scripts

Question

I'm trying to generate a script of my database in order to recreate elsewhere. Using the script generated by SSMS/Generate Scripts, I receive lots of dependency errors / warnings i.e. although an object is created, I get a warning saying that it's dependent on another object and won't work until that object has been created. Why are the objects not created in order of dependency ? I have tried using a number of version of SSMS 18.10 onwards but there's no difference.

Thanks,
J

Answer 1

Hi @JamesProsser ,

In SSMS, go to Tools->Options->SQL Server Object Explorer->Scripting. In the section Object scipting options, check Generate script for dependent objects. Then in the scripting context menu, select DROP and CREATE TO. (Only CREATE TO does not seem to honour this option.)

Refer to this similar thread to get another solution.

---

If the answer is helpful, please click "Accept Answer" .