Is there any way to migrate the whole database schema from one server to another server like View, function, sp, trigger, users, tables, etc?
I tried the option to migrate the DB schema using generate script (Instance->DB-> Task-> Generate Script -> used both options entire database and specific table, sp, view, etc.)
After migration, I have compared the objects (View, function, sp, trigger, users, tables, etc). I found some missing objects (View, function, sp, trigger, users, tables, etc) which were dependent on other user databases objects.
Also, I found some missing database system objects(View, Store procedure, tables, etc).
Can you help me, why system objects are missing (View, Store procedure, tables, etc) on user databases?
How can I migrate the system objects (View, Store procedure, tables, etc) in the same user database system folder?
Many Thanks!!
Nirvesh