5
votes
Accepted
SQL Server client for Ubuntu
Thanks for your answers. Your suggestions sound good but they weren't as easy to start as what I used, which is DBeaver, a universal database tool for developers and database administrators.
Easy ...
- 221
4
votes
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/
- 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 ...
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.
...
- 365
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 ...
- 61
2
votes
SQL server and client for Ubuntu (Debian)
I recommend you use PostgreSQL.
It is a very advanced relational database system. Its very close to the ANSI-SQL:2008 standard and has a lot of features that might come in handy further down the road....
- 3,020
2
votes
Accepted
Free SQL test data generator
I would recommend Mockaroo.com. It does generally what you are looking for and i think it should be able to get the job done. Here is what it can do.
generate test data(up to 1000 rows)
it generates ...
- 688
2
votes
MS SQL client providing read-only mode
I think the only safe way to do this is on the DBMS side. Like you said, some user might do something wrong by accident, or worse, could do something wrong on purpose. In SQL Server you can add the ...
- 323
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 ...
- 3,108
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 ...
- 3,108
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 ...
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), ...
- 241
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 ...
- 2,516
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 ...
- 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 ...
- 111
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)
...
- 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 ...
- 2,296
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 ...
- 2,296
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 ...
- 364
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 ...
1
vote
Tool to generate SQL database update scripts
I would highly recommend SQL compare from Redgate:
http://www.red-gate.com/products/sql-development/sql-compare/
It seems to have the features you need. Another of their tools, 'multi script' would ...
- 111
1
vote
Accepted
Tool to generate SQL database update scripts
No, there is no tool for doing all that you ask, not with 100% success and not with complete coverage.
Missing pieces, meaning objects added later in one of the instances, is tough enough. But ...
- 3,108
1
vote
Fastest JDBC driver for SQL Server
jTDS is an open source JDBC implementation for Microsoft SQL Server.
This benchmarks shows jTDS as faster for many tests, and in particular more than twice as fast as competitors for the "...
- 19.2k
1
vote
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 ...
- 3,108
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 ...
- 2,245
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 ...
- 121
1
vote
SQL Server client for Ubuntu
You can try SQuirreL SQL, the universal SQL client.
From the website:
SQuirreL SQL Client is a graphical Java program that will allow you to
view the structure of a JDBC compliant database, browse ...
- 1,810
1
vote
SQL Server client for Ubuntu
If Microsoft are providing a true SQL Server then just about any SQL client should be able to access it but a lot depends on what you need to do - admin tasks will often need more specialized tools.
...
- 31.4k
1
vote
What software do I use to process year by year calculations for large datasets?
For me it sounds like MongoDB would fit here. Some people say Headoop is for terabytes and MongoDB for Gigabytes. MongoDB offers a convenient aggregation framework which is easier to use than ...
- 957
Only top scored, non community-wiki answers of a minimum length are eligible