Free Databases from Murach

  • Thread starter WWGD
  • Start date

WWGD

Science Advisor
Gold Member
4,242
1,802
Hi All,
Free databases from Murach's book:

Note these are not a ripoff; these databases are used in the book whose link is above. You can save them as .sql or text files and run them as a query. I just installed them.
 

fresh_42

Mentor
Insights Author
2018 Award
11,065
7,605
Does it have a shell included, or is it only the server? As in "Here is your new database and there is the link to toad!" And is it better than MySql?
 

WWGD

Science Advisor
Gold Member
4,242
1,802
It is in .sql, which is just a text file. You can just open it, copy the full text, paste it and run it as a query. I haven't tried with MySql. I know it runs in SQl Server and I got my new database in less than a minute. EDIT: These are the databases to be run with SQL Server, maybe MySQL; not the full server.
 
Last edited:

fresh_42

Mentor
Insights Author
2018 Award
11,065
7,605
So it's just a bunch of scripts? At least as far as I could see. I haven't checked the executive, but the name suggests, that is only a self-extracting file for the scripts.

I thought it was a database server, possibly including a shell. Who needs scripts?
 

WWGD

Science Advisor
Gold Member
4,242
1,802
So it's just a bunch of scripts? At least as far as I could see. I haven't checked the executive, but the name suggests, that is only a self-extracting file for the scripts.

I thought it was a database server, possibly including a shell. Who needs scripts?
If you want a server download SQL Server or My SQL for free. I need the scripts to practice querying. Specially for reasonably-large databases/tables.
 

fresh_42

Mentor
Insights Author
2018 Award
11,065
7,605
I have once installed another database (HyperFile) including shell and ERD tool. It was part of a programming IDE for lazybones. You can write programs in hours and the installation doesn't require to set up the system for days, as in VisualC e.g. Unfortunately only the demo version, which runs out in time. But it can handle large files pretty well. If I had to deal with databases more often, I think I would buy toad as a shell. Never seen something better, including the shells that came with the database servers from Oracle to MySql.
 

WWGD

Science Advisor
Gold Member
4,242
1,802
I have once installed another database (HyperFile) including shell and ERD tool. It was part of a programming IDE for lazybones. You can write programs in hours and the installation doesn't require to set up the system for days, as in VisualC e.g. Unfortunately only the demo version, which runs out in time. But it can handle large files pretty well. If I had to deal with databases more often, I think I would buy toad as a shell. Never seen something better, including the shells that came with the database servers from Oracle to MySql.
But I dont think scripting a database is simple. Do you script your own?
 

fresh_42

Mentor
Insights Author
2018 Award
11,065
7,605
Not in the case described above. There you only modell it and let the shell do the job, including all joins. In SQL you only have those create scripts. Once you have one, you can easily build copies of it.
 

WWGD

Science Advisor
Gold Member
4,242
1,802
Not in the case described above. There you only modell it and let the shell do the job, including all joins. In SQL you only have those create scripts. Once you have one, you can easily build copies of it.
I think we may be using the term 'script' differently here. The script as I am using it is the code you run to generate the full database.
 

Want to reply to this thread?

"Free Databases from Murach" You must log in or register to reply here.

Related Threads for: Free Databases from Murach

  • Posted
Replies
6
Views
2K
  • Posted
Replies
10
Views
1K

Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving
Top