Generate sql script?

The web site I am building is working fine locally, but I am hitting some problems with setting it up on a remote hosting server.

First off, how can I generate the sql script to populate the SQL db on the remote server?
I am using VS 2005 Standard. Do I need to d/l the SQL Server Express?

Once I get that going, I should be able to figure out the rest...but I'll prolly have another question or two.

Thanks

Hi

To generate sql script ,you can take a look at this :How to: Generate a Script (SQL Server Management Studio)

|||

I suggest you install Management Studio Express to mange SQL Express databases if you haven't installed it yet, you can download it here:

http://msdn.microsoft.com/vstudio/express/sql/download/