Best way to dup database?

Hello, I have a SQL Server database that I wish to duplicate into my DiscountASP.NET database.

This thread references this blog:

which discusses various possibilities using SQL Management Studio.

Does Discount ASP.NET support the Database Publishing Wizard? If so, what are the settings?

I have successfully used SQL Management Studio to "Generate Scripts" that create and populate the entire database. I saved the result to a .sql file on my local disk, that I tried to execute on the Discount ASP.NET server using a SQL query window.

But the script references e.g. the name of my database, which is not the same one that was created for my Discount ASP.NET account, and I got many errors. Do I have to edit the .sql file? How?

I have also used the SQL Management Studio Copy Database task successfully, but it is a pain because it does not do things like preserve Relationships (foreign keys) and Update/Delete behavior (like setting to Cascade); I have to set these manually, after the Copy Database is complete.

Please! Tell me there is a straightforward process of duplicating a database to and from Discount ASP.NET.

Thanks,
David