Using PowerCMS 2 on localhost to maintain a Site Sculptor site
Here's the process I'd suggest.
1. Create your Site Sculptor Site including CMS and upload and install on the live server.
2. Download the files from your live server to your localhost and define a DW site to that location.
*3. Export the .sql from your live database and import to your local database.
4. Following this tutorial for upgrading the CMS, upgrade the localhost CMS to PowerCMS 2. upgrading-ss-powercms.php.
5. When you are finished making your changes, you will need to upload any new files (make sure not to upload and overwrite the CMS files). Also, you will need to export a .sql file from your local database and replace the live database.
*If you are modifying a site after your client has been modifying content, you should not overwrite the entire database on the live server because you will overwrite your customers changes. Instead, you should create a .sql dump of the live database and import that to your localhost version. You should then disable the live CMS while you make your local changes. Once you are done, you can export your local db and import to the live db without worrying about overwriting your client's changes. Once you have confirmed everything is correct, you can re-enable the CMS.
If we see this as a common use case for our Developer community, we will definitely put some more thought into making this workflow more accommodating.