Menu
I have been using database project in Visual Studio 2010 to maintain/version control database schema and are quite happy with that since I can also use VBDBCMD to deploy the version controlled schema to any database instance quite easily.
Now I need to work with PostgreSQL and I am wondering if there is any tool similar to the "database project" thing in Visual Studio to help version control database schema as well as schema deployment.
Thanks.
672
and select PostgreSQL: New Query (this will open a blank file). Step 2: Next, you need to select a Postgres Server (click on the icon Select Postgres Server ) in the side bar (at the bottom) of the Visual Studio Code user interface. Select the server of your choice and choose the default database postgres .
Start with PostgreSQL if you want to not just learn the basic RDBMS constructs but also work with advanced and in-demand features. PostgreSQL handles semi-structured data such as JSON and has great support for distributed SQL. The latter is useful when working with millions of transactions on the web.
Launch Visual Studio and select Create a new project. Search for database and select SQL Server Database Project. Click Next. Enter the name of the project.
The closest thing I could suggest would be Eclipse with the Toad plugin.
In general, shopping list questions are disfavored on Stack Exchange sites because they tend to solicit opinions and tend to go out of date quickly.
The other option is to use a source code management solution like git or subversion, and then just use your standard text editors on the SQL files. This is what we do in the LedgerSMB project.
122
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
