Here is full details about new Azure Staging Feature. And it says
Some settings from the staged version will automatically copy to the production version – including things like connection string overrides, handler mappings, and other settings you might have configured. Other settings like the DNS endpoints, SSL bindings, etc will not change (ensuring that you don’t need to worry about SSL certs used for the staging domain overriding the production URL cert, etc).
What i don't understand is, it says connection strings are overrides. When i do swap connection strings, they swap each other. So in that case, my staging website database become production database. What i expect is, it doesn't touch connection strings at all and my production site will continue to use same database but it use staging database because connection string swap each other.
Is it possible to configure staging website for not to replace connection strings ?
It isn't wrong design by azure team that swapping cause to use test database on production website ?