4 votes
Accepted

Which software can I use to browse a MSSQL database?

Not sure if this will work for you, but you could try: DBeaver https://dbeaver.jkiss.org/download/
Cody G's user avatar
  • 156
3 votes

Complex SQL Query visualizer

This online SQL parser visualises data flows and table joins in SQL statements -- see demo. It comes with a free tier. disclaimer: I am co-founder of SQLdep (somebody who got too lazy to manually ...
Martin Masarik's user avatar
3 votes

Complex SQL Query visualizer

Python based reverse snowflake: http://revj.sourceforge.net
Sun's user avatar
  • 381
3 votes

Database schema visualization for MS SQL Server

SchemaCrawler is a free, open-source database discovery tool that can reverse engineer your existing Microsoft SQL Server 2008 database. Take a look at examples of the SchemaCrawler Database Diagrams. ...
Sualeh Fatehi's user avatar
3 votes

Database schema visualization for MS SQL Server

SAP PowerDesigner does the job but it's superexpensive (I think ~5000+ EUR per seat). The feature is called "reverse engineering a database". You just point it to a database (not just SQL Server but ...
bogdan's user avatar
  • 61
2 votes
Accepted

What is the best frontend program for my database needs?

FileMaker FileMaker is a relational database client server database that run on Mac, Windows, iOS, and web. It combines a database server with a form-building tool and a proprietary programming ...
Basil Bourque's user avatar
2 votes

Which tool to use for SQL Server Database migrations and why as of 2017?

There are two main products that I'm aware of in the relatively new field of database migration. Flyway Flyway is basically a tool to organize, track, and automatically apply a collection of SQL ...
Basil Bourque's user avatar
2 votes

SQL Server database version control

Plain text files, in Git/Mercurial Use your source code version control such as Git, as you mentioned, or Mercurial. Track the creation, definition, and evolving changes as SQL scripts. These are ...
Basil Bourque's user avatar
2 votes

What software should i use to create a ERP SYSTEM?

Too long for a comment, so I will have to post this as an answer … How many years do you have available for the project? Because it *will take years (at a rough guess, man-decades). Spend a good ...
Mawg says reinstate Monica's user avatar
2 votes

open source tool for SQL Queries

Pretty much any maintained open-source SQL Editor may be suitable for you. It really depends if you prefer also to be lightweight: Squirrel SQL - small footprint, universal (both source and os), ...
Kube Kubow's user avatar
2 votes
Accepted

Tool to get the most proper SQL for a predefined result

Seems to me that you are asking for a software that helps you find a "cover", a smallest set of the "Functional Dependencies" which can generate all the given rules that are ...
knb's user avatar
  • 2,844
1 vote

Recommendations for creating wallboard-type displays using MSSQL data sources

Syncfusion Dashboard is an end to end Dashboard solution that can be used to create wall board type displays from SQL Server (or other data sources). The specific requirement of having a dynamic ...
Davis Jebaraj's user avatar
1 vote

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise?

Oracle has no customers, they have hostages only. Microsoft SQL Server is well designed database with a lot of documentation accessible. However it works on Microsoft platforms mostly, which gives you ...
kakaz's user avatar
  • 111
1 vote

PHP MSSQL Table editor in browser

Have a look at Adminer. It's a litte Web App that supports MS-SQL and provides comprehensive database editing features (data and tables/meta data). Just install it on a PC with XAMP or run it on a ...
WeSee's user avatar
  • 282
1 vote
Accepted

Software to build networks visualization using relational tables

You could do this in R: # some newer libraries for dealing with networks library(ggraph) library(tidygraph) theme_set(theme_void()) #read in data txt <- read.table(text = " Partner_ID ...
knb's user avatar
  • 2,844
1 vote
Accepted

Which Software to take, when creating a database diagram

You could use Visual Studio/SQL Server Manager GUI to create a "Create table/View/index..." script that creates a long list of SQL DDL statements, enabling you to create a copy of your database (...
knb's user avatar
  • 2,844
1 vote
Accepted

Which database to use for making a small inventory management system?

10 GB is a huge size for a database. Are you sure that your database will be so large? If you're familiar to programming in Java, you could use H2. I know that OpenConcerto which is an accounting/...
OuzoPower's user avatar
  • 343
1 vote

SQL Editor for Microsoft SQL server

I recently started using DBeaver and I like it very much. Some of its features: free and open-source runs on Windows, Linux, Mac OS X, Solaris (eclipse plugin available) supports relational DBs (...
coreuter's user avatar
  • 166
1 vote

SQL Editor for Microsoft SQL server

You could try using Devart's dbForge Studio. It has: Code completion — to create whole SQL statement in a few keystrokes. SQL formatting — to follow common coding style (standard). T-SQL Analyzer to ...
Chillie's user avatar
  • 341
1 vote

Which tool to use for SQL Server Database migrations and why as of 2017?

In our project (Azure hosted dotnet core application) we use EF Core to manage DB migrations. The setup looks like this: There's a separate C# project with entities (EF Code First models). There's a ...
Ivan Samygin's user avatar
1 vote

SQL Server replication tool

I was about to post a similar thread when I stumbled upon your question... Since you got no answers so far, I am leaving here the outcome of my research: Symmetric DS (open source, written in Java) ...
Veverke's user avatar
  • 211
1 vote
Accepted

Reporting tools when using SQL server management

Syncfusion Report Platform is an option to consider. Based on SQL Server: Yes Web oriented: Yes. Quick to Build: Syncfusion Report Platform uses the same file format (RDL) as SSRS. A Desktop ...
Davis Jebaraj's user avatar
1 vote

What is the best frontend program for my database needs?

I have done something similar using Drupal content management framework running on a company's intranet. By default it gives you a multi-user environment. You can even expand it with its LDAP module ...
Z Z's user avatar
  • 2,445
1 vote
Accepted

SQL Data verification framework?

After a bit of searching I found a commercial solution which I think would solve the problem: QuerySurge. There are a couple of similar tools like this (ETL validator), though it claims to be unique ...
Richard's user avatar
  • 121
1 vote

Tool for deploying web-project to the server

Saltstack will do everything that you're asking for. Here's a good place to start using saltstack.
trueCamelType's user avatar
1 vote

Software library or tool to pivot and export a lot of data to Excel

While I haven't done this exact sort of thing myself I would recommend installing Python and Pandas. This combination can: Directly query your database(s) Perform pivots with a little care on ...
Steve Barnes's user avatar
  • 31.5k
1 vote

Web-based OLAP CUBE browser?

I have conducted a trial of Kyubit and it is a very good portal for OLAP dashboards. They have an aggressive release cadence with frequent improvements to their functionality. For a small to midsize ...
Howard Fulks's user avatar
1 vote

Web reporting from SQL Server

Syncfusion Report Platform is an option to consider. Click an account and see the banking transactions for that account: Can be done using Report Filters Export data to Excel: Excel export is ...
Davis Jebaraj's user avatar
1 vote

Web reporting from SQL Server

Most BI/Reporting tools have a trial period you can use to test it, so you can easily test many and pick the one that better fits your needs; in any case, i recommend you to test DBxtra, as it lets ...
Miguel Garcia's user avatar
1 vote

Tool to generate SQL database update scripts

A little late, but I will add my tip just for the record: https://www.schemacrawler.com/ It won't do the SQL generation, though, you'd have to do that yourself. I've used it's output (as well as ...
jon martin solaas's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible