Two people sharing a workspace

Ana creates the workspace, registers the servers, builds the target groups, and commits:

estate/
  Estate.smcworkspace
  connections.json          committed — no passwords in it
  distributionLists.json    committed
  environments.json         committed
  Projects/
    Release/Release.smcproj committed, with its .sql files

Ben clones the repository and opens Estate.smcworkspace. He has every connection and every target group immediately. What he does not have is the passwords — those live in Ana's credential store on Ana's machine — so the first run prompts him for each one, and saving them puts them in his store.

If Ben's copy of one server is on a different host, he does not edit connections.json. He overrides it locally (§6), which writes connections.local.json. That file belongs in .gitignore:

connections.local.json