SQL Database Publishing wizard vs regular scripting

is there more benefits in trying SQL Database Publishing wizard compared to the regular right click and script and pick and choose the objects that you want scripted?
LVL 5
25112Asked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
with the data and everything? backup and restore is the prefered way.

or if you can take that database offline, you can detach, copy attach
0
 
25112Author Commented:
the idea would be completely recreate a database on a different server.
0
 
25112Author Commented:
backup/restore works.. but in this case.. we want the scripts to be created with a new collation.. hence we cant use backup/restore..

with data is best.. but will be content just with the scripts..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.