When i created a SQL Script using the Database Wizard for a database i found that the script is not getting created in the proper order. The User Defined function script is getting created at the last and Views are created before. If i am using this User Defined function in the create View which is executed before creation of functions i am getting error when i run the generated script in sql Client.
I would not use the database import wizard. I would run individual SQL scripts in the necessary order using batch mode. That way, you can control which script(s) run before other scripts.
