ASP.NET Deployment Questions
I'm almost finished developing my first ASP.NET4 Website and I bought a Windows hosting with PLESK. Now I have some issues that I don't know how to address.

I've read that the Database Publishing Wizard builds a .sql with Schema/Data that I can run on my remote database. However, this only seems to work on a first upload of the website. The remote database will have user generated data and what happens if I add a new table or a table field to my local database? I can't generate a new .sql since that will erase the remote database, how is this issue adressed?

I've also thought that I can upload the database and then only work remotely but this doesn't seem right for test purposes.

Also, I'm publishing my website through FTP since PLESK doesn't support Web Deploy. Is there a better way so my databases are somehow synced?
ASP.NET Deployment Questions
===

I'm almost finished developing my first ASP.NET4 Website and I bought a Windows hosting with PLESK. Now I have some issues that I don't know how to address.

I've read that the Database Publishing Wizard builds a .sql with Schema/Data that I can run on my remote database. However, this only seems to work on a first upload of the website. The remote database will have user generated data and what happens if I add a new table or a table field to my local database? I can't generate a new .sql since that will erase the remote database, how is this issue adressed?

I've also thought that I can upload the database and then only work remotely but this doesn't seem right for test purposes.

Also, I'm publishing my website through FTP since PLESK doesn't support Web Deploy. Is there a better way so my databases are somehow synced?