How to work in a dev environment with sonata project?

Question

symfony

It's a simple question, but I haven't found an answer yet.
There is a deployed project on symfony, which is written down on sonata, works on a local computer.
And there is also a remote test server, the same project is also deployed there.
When working from the local version, updates are rolled out, including to the test (remote) one.
All these projects use one single database that runs on a remote server.
And then the question is how to do it right, if, for example, the remote server is available on the sonata-host.ru domain,
then I need to create the sonata-host.ru domain on the local version so that the project works and you can look at the results of work in the local version, and you also need to be able to view the remote server.
The problem converges in that the link goes to one host, which is entered in the sonata configuration, stored in the database, in the page_site table.

Answer 1

All these projects use one single database that runs on a remote server.

Badly.
Use local bases.
Use migrations to synchronize the structure.
To create test content - fixtures (doctrine/doctrine-fixtures-bundle).