I would like the script to make changes made by comparing schemas between two SSDT projects, but the "generate scripts" button is not available / disabled when the source and target are SSDT projects.
The Refresh button is not gray. If I want to update directly, I can. But I need scripts because I use these two controls on two database environments that are not on the same network (but they need to be synchronized with the db schema and code promotion).
In addition, to check and strengthen, if my goal is a real database, not a project, I can generate scripts. Its only when the goal is a project that I cannot generate scripts. Unfortunately, I cannot connect directly to the target database.
I would really like for the local copy of the database of each of my DB client environments to be local only for script generation (I already have SSDT projects for each).
Is this an intentional restriction? Seems strange. I cannot be the first guy to manage a client scheme with which I cannot directly connect to my dev machine.
source
share