Maybe not the greatest solution ever, but the cheapest one if measured by required effort is conversion of your Access database to SQL Server, preferably to Microsoft SQL Server.
In Microsoft Access'97 and 2000 there was even a tool called Upsizing Wizard doing exactly this thing.
Most important facts:
MS SQL Server is free until it runs single CPU core ...
I have used and recommend Saiku.
It is a Pentaho plugin, you have to install it from Marketplace after you have installed and launched the Pentaho BI server.
Saiku allows you to explore and drill down data with a nicer interface than Pentaho's default.
It also allows you to quickly create graphs:
To create more advanced reports/dashboards, Saiku also ...
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 pretty much any major RDBMS) and it creates a much more powerful diagram than you get in SQL Server's built in feature. It can do a LOT more than just aiding ...
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 installation with .deb installer, ready to start in 1 minute
Easy to use
Free (GPL2), open-source and multi-platform
It supports MS SQL Server (as requested in the ...
I would use MySQL as RDBMS and MySQL Workbench as IDE:
works on Windows/Linux/Mac
straightforward to install (to make it simpler you could even install MySQL on some server, and just have your interns connect to it)
SQL documentation on the side
in addition to the SQL Editor, you can design visually database (usual ...
I'd give them sqlite - it's perfect for beginning situations like this:
The DB is in a single file, making it really easy to start using, and really easy to reset if you screw it up.
The DB engine is a single executable - just type sqlite3 <db file name> to get started.
Imports from CSV are pretty easy.
Supports the usual set of SQL operations.
I would recommend phpMyAdmin - works with MySQL (also MarioDB & Drizzle though I can't comment on the those). It does require PHP and MySQL/MarioDB/Drizzle - WAMP has it pre-setup through the installer if you want a simple Windows installation solution.
With phpMyAdmin you have full console abilities and also a very very easy to play with learn from/use ...
I would recommend you to use an ETL (wikipedia), it will help you extracting data, optionnally transform then load it to any other database, report, or even flat files (CSV, Excel, or whatever).
There are many tools you can check, have a look at Talend Open Studio, it supposed to provide you easy and elegant way build ETL jobs without writing a single code ...
Actually there are a lot of apps with some similar features and with some differences. I'd made a short presentation for inner clients during my work to choose an app for us. As a user of BI, not a developer, I looked at app from simple point of view. I wish it works fine, do what I need for the cost we can pay. As i understood there is no full web-analog ...
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.
If you are just starting to get to know relational databases Postgres will teach you a lot of function that you will find (in one way or another) in other ...
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, SchemaCrawler
Have you tried Heroku before? You can push to it just like Github.
Well, you can do the same on your own host if you have root access by installing git and setting up a hook that will check out the code to your webserver's folder. A detailed how-to for this can be found here on Toroid.ORG.
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 very realistic data
you can download the data in the form of a sql file
It does not make a direct connection to the database. It also cannot generate data with ...
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 user to the db_datareader role which only allows the user to do SELECT:
Members of the db_datareader fixed database role can run a SELECT statement against any ...
Am using PostgreSQL(open source database) on my VB.NET Desktop Application.
I think you need an embedded database to use within the application, Microsoft SQL Server Compact if you don't want to install anything on the user side
Firebird Embedded is a
relational database engine. It's an open source fork of InterBase, is
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 plain text files, and can be kept along with your app project or in a separate project of their own.
As these are just text files, you do not need any special ...
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 few months coming up with requirements; then have someone review them (do you have a customer or end user?) .
Then spend longer on an architecture. Review.
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), actively developed java tool. Visual interface is very basic and not intuitive (like in Access).
Execute query - pretty much the same as squirrel, but not that ...
I would highly recommend SQL compare from Redgate:
It seems to have the features you need. Another of their tools, 'multi script' would permit the deployment to multiple instances:
We've been using these for a while and they've been rock ...
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 alterations such as changed names, altered data types, dropped columns or tables, and so on make periodic compare-to-sync impossible.
Database diff tools
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 "ResultSetReadAllRows" test:
The benchmark has been made by jTDS, so I am not sure how reliable it is, though. Other benchmarks would be welcome.
Drawbacks: jTDS is ...
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 language. Very simple to get up and going quickly. Has built-in features for user to do data-entry, exporting, reporting, and printing. Also has full JSON and ...
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 to enable login using Active Directory/LDAP accounts.
It uses MySql database. You can email users, add images, files, etc
You can create "content types" for ...
You can go with Stellar Phoenix SQL database repair software. As I had used this tool previously when my SQL server 2012 database was corrupt. I had tried DBCC CHECKDB with repair_allow_data_loss but got same error message. I had downloaded three tools: Stellar Phoenix, Kernal & systools but Stellar Phoenix suited me best. Finally bought this tool to ...
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 software.
It works by:
Using set comparison between 2 queries, raising errors if they do not
match. This could be row counts before/after transformations, or
I assume you are trying to build a web application. You can use SchemaCrawler to generate metadata (schema and table structure) of your remote SQL Server database in JSON format. Then, you can display this JSON data in any way you please in your PHP application.
Sualeh Fatehi, SchemaCrawler
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 MapReduce functions.
You could either use he console or any GUI application like MongoChef or implement a C# ASP.NET application or even in any other language you can ...
Take a look at Nagios. It is free, open source, generic monitoring software.
You can monitor SQL Servers from Nagios by sensing queries and checking results, or by dedicated plugins: check_mssql_health or check_mssql.
Nagios Core and Nagwin ports work on Windows Server platform.