Compare a project to a schema Follow Bill Soranno Created February 04, 2020 19:09 Is it possible to compare a project to a schema?
I have this same question and would like to know the answer. I assume this question is related to a feature in VS where you can select your project's schema files and compare them to a live development or production database to see what differences are there and update the database in place.
Bassicallychris you are correct. I currently use VS with an extension from another company for MySql. I would like to switch to DataGrip, but I have a few requirements and I cannot find the answers in the doc.
1. Does DataGrip have a concept of a project similar to VS?
2. Can the project be under version control?
3. Can a schema compare be done from a project to a database?
1. Could you explain VS project concept?
2. If you mean sql files - yes, if not - follow https://youtrack.jetbrains.com/issue/DBE-3852
3. What do you mean by "project" ? Is it sql files?
Also, read blog post about git + DataGrip https://blog.jetbrains.com/datagrip/2018/06/01/tutorial-how-to-use-git-with-datagrip/
1. A Visual Studio project is a set of files that make up the project. It also includes files that the IDE maintains about the project, for example what folder and sub folders are defined in the project. Also, the same concept of a project that PHPStorm and WebStorm have. Here is the Microsoft definition of a project: https://docs.microsoft.com/en-us/visualstudio/ide/solutions-and-projects-in-visual-studio?view=vs-2019 Here is the definition of a project by jetBrains: https://www.jetbrains.com/help/phpstorm/2020.2/creating-and-managing-projects.html?utm_source=product&utm_medium=link&utm_campaign=PS&utm_content=2020.2
2. Yes sql files, but other files too.
3. See 1. for definition of a project. It does contain sql files, among others. The compare will do a compare of the files in the project to the objects in the database and report the differences. Then you can choose the differences to push to the database. They could be new objects, or changes to existing objects.
I see,the only thing IDE supports now is bundle with git plugin as mentioned in the article https://blog.jetbrains.com/datagrip/2018/06/01/tutorial-how-to-use-git-with-datagrip/ and you can create a project in DataGrip as well (don't forget to enable Welcome screen)