Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
but i am interested in knowing which SQL program i can use that is most compatible with
MS SQL server...
im not running anything... "important" in terms of a critical servers...
im just a student thats taking a intro database class, and they just happen to use MS SQL Server.
thus i would like to "learn" the equivalent of it on the *NIX side...
(My SQL, Postgre, DB2, Oracle? etc...)
the important aspects im looking for similar (or exact) like MS SQL Server:
- SQL Query Analyzer... (where i can input CODE, and then just run it... displaying tables, etc.)
- perferbly GUI interface...but console is not a problem
- enterprise manager, where i can access, create databases
Distribution: Lots of distros in the past, now Linux Mint
Well, not to dissuade you but most SQL DB's aren't "standard". What I mean is that you're going to have to unlearn a lot of things to move from one to the other. This holds true for commercial and OSS DBs, mostly because there is no good SQL standard. Because of the tug of war between players, SQL is more of a misnomer than a standard. However, once you learn SQL fairly well, your knowledge should translate to other DBs reasonably easily.
I'd recommend looking at MYSQL, Postgre, IBM's DB2 and Oracle as the better ones, depending on your needs. None is perfect, but they tend to work with each other a whole lot better than MS's implementation does. Not that it's terrible, because it is used alot, but you'll make more money learning the other's versus MS's "mom and pop easy" DB.
I use Mysql, partialy because it's OSS, but also because it hooks into almost every programming language out there.