ASP.net DB Question

[Bakedgoods]

Hey guys.

When kaking an ASP.NET website do you create the database inside your website through Visual Studio, or do you set it up seperately and manage it through something like SQL Management Studio?

 

[Bakedgoods]

That's what I have done previously but just wanted to check.

Thanks

Another question. I've never had to upload an SQL database and website that i've developed to web hosting. Any tips on the easiest way to do this?

I'm with tsohost if it's any help. It was a nightmare last time and I had to have a member of the staff do it for me.

 

[Bakedgoods]

Now i've heard this mentioned before about different directories and the .NET stuff but i've got very little understanding. Is there anything I can read?

It's only important if you have more than 1 ASP.NET site on your hosting isn't it?

Regarding the DB, that makes sense. Create the DB online, remotely connect to it and configure it through Management Studio. However, what about testing this locally?

What I mean is, I'd imagine you'll create a website locally, and the DB to test everything? Or do you use your hosted database from the go?