.NET Membership/Roles for SQL 2008 and WebMatrix

I am having major issues configuring role/member login on my SQL Server. I am using WebMatrix connected to a local version of SQL Server 2008 R2 Express. The apps work fine locally, but bomb when loaded to the remote server.

I have seen the KB article on configuring ASP.NET Membership/Roles Provider to use SQL 2000, SQL 2005 or SQL 2008 and have not done so yet. Before I do, here's my question:

Since I already have a lot of data on the DASP SQL Server instance, assuming everything goes correct with the configuration in the KB article, does this mean I cannot use the "Publish database" option once I configure the roles/membership? WebMatrix says it will overwrite the existing database. If I add more tables locally to my SQL Instance, will WebMatrix wipe out all the role/membership tables that were created using the command line the next time I publish from WebMatrix and select the database checkbox? WebMatrix has a warning that says your DB will overwrite any existing. How do I add/remove tables locally while not mucking up the role/membership tables on the remote SQL Server when I publish?