What is the right way to publish a web site that uses a SQL Server 2005 database, including asp .net membership tables and sprocs generated using the asp .net regsql tool? Should we use SQL server 2005 publishing wizard to export the schema and data? Is there any other setting that is required to mimic all that the aspnet regsql tool does?

Thanks

Anand 

There are several ways to do this

1) Detach the aspnetDB from your computer and attach it to the remote SQL server

2) Use aspnet_regsql tool to recreate the asp.net membership schema directly on the server.

3) Script the database on your local computer and then execute the script on the remote server.

If you do not have a lot of users setup, I find it easiest to just create a blank membership