Recommended Posts

Hi guys.

I need to change the server for the company I work for... yes I'm a sysadmin, unfortunatly I have a windows based network (I have also a microsoft certificate, for windows 2000 AD Administration.. :( ).... anyway the main thing becuase we use Windows 2000 Server is SQL Server.

We use a lot of applications, designed especially for our needs, that runs on SQL Databases, and of course on windows clients... but that's not the big deal. I'd like to change my Windows 2000 server in a Mac OS X one... and leave all my windows clients... at least for now. The only main problem is that I couldn't find anything equivalent to SQL Server on Mac OS X... does anyone knows some good alternatives, that can run smooth on Mac Os X?

PS: I wanted to ask this on the thread about Mac OS X Server, but was closed due to some trolls...

PPS: the :( about the certficate was a joke... I'm pretty happy about that, since I can use and know more than a single OS.... :D

Link to comment
https://www.neowin.net/forum/topic/169662-sql-on-mac-os-x-server/
Share on other sites

As far as i know, it's not faster and reliable as SQL Server is (at least for now...) and, but I could be wrong, don't work natively under OS X, but under X11..... I can't go and tell my boss, let's switch to mySQL... it can be slower... but hey, who cares? ;)

I just wished a long for and iSql apps.... :D

MySQL is pretty fast and reliable, but I wouldn't use it to run my business. Postgres has had a lot of the features from more advanced databases for a while including 2 phase commits, constraints, referential integrity, etc...

Oracle exists on OS X but there is one major problem: it's in perpetual beta. Maybe that will change at WWDC but I wouldn't hold my breath. Even if it does, can you afford it, and do you want to put up with it's terrible default toolset or do you want to buy good ones from third parties?

Don't feel bad about the MCSE cards: if I didn't get mine i might still be using Windows today.

Why would you want to waist your money and buy a Mac Server if your current setup works fine now?

Also, if they are made to work with Microsoft SQL Server 2000, its very unlikely you will get them to work with anything other than it.

Also, if you are running AD, there isnt anything like it for Mac OS X server to my knowledge.

  Quote
Why would you want to waist your money and buy a Mac Server if your current setup works fine now?
Are you an administrator at his company? Do you have Microsoft and Apple certifications? Are you intimately familiar with what his needs are?

If not, why don't you let him ask for help doing what he wants rather than explain to you why he wants to do it?

  Quote
Also, if they are made to work with Microsoft SQL Server 2000, its very unlikely you will get them to work with anything other than it.

Are you saying Microsoft implimentation of SQL is so broken that it's no longer standards compliant. That's not my experience (and I used MsSQL Server as one an elective when I got my MCSE for NT4 so I'm not exactly illiterate). While MsSQL server is a little weak compared to the likes of Oracle and DB2, it's pretty respectable all the way around for a small-medium sized businesses that has outgrown Access and the like. It still follows the same standards that everyone else does.

  Quote
Also, if you are running AD, there isnt anything like it for Mac OS X server to my knowledge.

Speaking of literacy, you might want to practice your own reading in the last thread you trolled-to-hell where people pointed you to the wonderful world of OpenDirectory which uses standard LDAP to provide directory access services. It's also worth nothing that OS X clients can authenticate against Windows ActiveDirectory servers if administrator would rather do things that way.

But hey, thanks for coming out.

  the evn show said:
Are you an administrator at his company? Do you have Microsoft and Apple certifications? Are you intimately familiar with what his needs are?

If not, why don't you let him ask for help doing what he wants rather than explain to you why he wants to do it?

Are you saying Microsoft implimentation of SQL is so broken that it's no longer standards compliant. That's not my experience (and I used MsSQL Server as one an elective when I got my MCSE for NT4 so I'm not exactly illiterate). While MsSQL server is a little weak compared to the likes of Oracle and DB2, it's pretty respectable all the way around for a small-medium sized businesses that has outgrown Access and the like. It still follows the same standards that everyone else does.

Speaking of literacy, you might want to practice your own reading in the last thread you trolled-to-hell where people pointed you to the wonderful world of OpenDirectory which uses standard LDAP to provide directory access services. It's also worth nothing that OS X clients can authenticate against Windows ActiveDirectory servers if administrator would rather do things that way.

But hey, thanks for coming out.

Listen; don?t talk about things you don?t know. It would require a re-write of the data code in the client application. Also,

All I asked was why he would do it if his current setup works.

Also, if you think that Microsoft SQL Server is week, then you really need to learn your stuff. The last release was in late 1999 (new one is coming soon) and it was only beaten for the first time by a slim margin in performance a few months ago, by an experimental version of Oracle. Many large, small, and medium sized companies use SQL Server.

Also, thanks for informing me about the open directory thing.

  area91 said:
Also, if you think that Microsoft SQL Server is week, then you really need to learn your stuff.

Read the comment: compared to Oracle and DB2 MsSQL is weak.

Two instances of Oracle can operate on the same data store - something not possible with MS SQL Server. It's feature set easily accommodates databases > half a terabyte in size where databases like MySQL and Postgres give up an die, and handles massive loads much better than any other platform. Ms SQL doesn't provide any clustering services (they were supposed to ship last year, but now, who knows when). I guess you can use federated databases to do get some level of clustering going on, but when one server goes down you're pretty much SOL as far as your applications go.

For security, oracle has passed > 15 (exact number escapes me off hand) security evaluations from various bodies. Ms SQL has C2 which is obsolete now. Woot for Microsoft! Maybe tack on encrypted traffic using AES or tripple-DES to keep private data away from sniffers, another security features not found on MS SQL. One simple reason to move away to Oracle would be to use Kerbos authentication with non-windows clients (which the OP clearly has).

I could rant on about why Oracle > MS SQL Server - but you're not listening.

Good night, and good bye.

Check the SAP SD Tier 2 benchmarks: oracle is king, same with ADO Tier 2. Then browse down to the SD Parallel benchmark and marvel as Oracle holds the top 7 spots, and that the others divide between DB2 and Oracle. Then search in vain for MsSQL which can't post any scores for SD Parallel.

  Quote
The last release was in late 1999 (new one is coming soon)
How do you propose people run their business on software that isn't available?

First longhorn, now some new version of MS SQL Server that's due Real Soon Now .

  Quote
and it was only beaten for the first time by a slim margin in performance a few months ago, by an experimental version of Oracle.

See above.

You can find cases where TinyDB out performs Oracle too, but that doesn't mean it's a better database. Also, while you don't provide any benchmarks to back your claim (in fact you'd need a history of benchmarks to prove yours), I'm pulling mine from the SAP standard application benchmarks.

EDIT: This also might have something to do with MS SQL's reliance on lock escalation to do row-level locking. Sure it saves memory, but it costs you data concurrency which can hardly be considered a good thing. Needless to say, Oracle doesn't need lock escalation to do row-level locking which in turn increases data availability (which MS SQL compounds during heavy usage), and reduces my requirements as a developer to check for deadlocks in my code.

  Quote
Many large, small, and medium sized companies use SQL Server.

How does that differ from what I said, or are you just being redundant?

Edited by the evn show

About the only viable option right now would be Postgresql for OSX.

Honestly, if you are working for a small to medium sized business, stick with MS SQL on for now on Windows server. Now that does not prevent you from having a mixed environment of OSX servers running Open Directory for file servers/web servers and mail/usenet servers with Windows servers.

Once Oracle comes out of beta, I would recommend taking a serious look at them again. If you used OBDC, only minor changes would be required (same with JDBC under Java). Now that MS and Oracle are working together again. Expect to see better OLEDB support in .NET for Oracle as well.

No flames please (you know who you are). :laugh: I work as a developer on Foxpro 8 and .NET accessing MS SQL and I have also programmed against MySQL on linux with Perl & DBI.

Woah.... than again it's turned out into anther flame!!! :angry: Why people can't post their comments without bashing? (You all know who am i talking to...)

Anyway... as i stated in my first post, I NEED to change the server, because in the last few months my company has grown, and we've seen that our current hardware needs an update in any case. So I've started to look around, IBM, HP, etc etc... than came into my mind that maybe I can find a good implementation on SQL that runs on OS X, so I can switch my server to OS X instead of Windows 2000. Mostly because, yes Area51, I THINK that OS X is much better than Windows, more reliable, and much more powerful.... and most important, more stabile.

So, my apps access to SQL database using ODBC, so I don't see why they should be platform dependent. I "hope" microsoft has implemented standard SQL in SQL SERVER (because they have done it, right? :shifty: ), if that's why apps should bother if I use Oracle or SQL Server? Don't they speak sql?!?

I checked mySQL, and I don't think it's suitable for me... the bad thing is that there isn't a gui for OSX yet... I'm giong to get posgresql and see it....

Thanks to all since now, and if I'm missing something, please enlighten me.... :D

  timdorr said:
ODBC is a standardized interface to a SQL server, no matter the vendor. Any application using ODBC can access and query a SQL server of any type, however the supported SQL statements may vary greatly between systems.

That's exactly what i was thinking about... I guess i'll try to install PostgreSql and mySql... mount my Dbs, and see if the applications works...

I'll let you know... :D

  shodan said:
That's exactly what i was thinking about... I guess i'll try to install PostgreSql and mySql... mount my Dbs, and see if the applications works...

I'll let you know... :D

you're not going to be able to mount SQL Server detached Databases on another database server, the file formats are different for each database server... and as for MySQL it is still missing a lot of features high end databases had like Oracle and Microsoft SQL Server... and some queries are still not SQL-92 Complient, so you still do run the chance of having non working queries if youre qureies are very complex.

This isn't a Microsoft problem, but something you will run into across any DB packadge... they all work differently. use different storage formats, and diffrent data providers for comminicating with them

  Quote
you're not going to be able to mount SQL Server detached Databases on another database server, the file formats are different for each database server

That's why god invented import and export routines. Oracle is the king of being a pain in the but to migrate away from (and even that's possible using CSV files and a few hours work).

As for MySQL being a little under powered: no doubt it's missing a bunch of the features from 'good' RDBMS software, but if he doesn't need them - then it works fine. If he's using say triggers then he'll have an issue. Once again God saw a need and provided us with Postgres, so all is not lost.

I've moved data from MySQL to Postgres to Oracle and had no issues that any reasonably capable DBA couldn't solve. I've even moved data from Oracle to Postgres once and while it was a total pain in the butt - it was doable (not something I'd try again without a huge paycheck in it for me though).

  the evn show said:
That's why god invented import and export routines.  Oracle is the king of being a pain in the but to migrate away from (and even that's possible using CSV files and a few hours work).

As for MySQL being a little under powered:  no doubt it's missing a bunch of the features from 'good' RDBMS software, but if he doesn't need them - then it works fine.  If he's using say triggers then he'll have an issue.  Once again God saw a need and provided us with Postgres, so all is not lost.

I've moved data from MySQL to Postgres to Oracle and had no issues that any reasonably capable DBA couldn't solve.  I've even moved data from Oracle to Postgres once and while it was a total pain in the butt - it was doable (not something I'd try again without a huge paycheck in it for me though).

eeek! there is still the issue of getting his software to work with it! unless you want to spend a good weekend hacking the program, your ******.

Edited by area91
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • I'm just waiting on what they will do when outlook doesn't load properly, and you have to set a new profile as a test.
    • Weekend PC Game Deals: Rhythm bundles, fishing festivals, and DRM-free summer sales by Pulasthi Ariyasinghe Weekend PC Game Deals is where the hottest gaming deals from all over the internet are gathered into one place every week for your consumption. So kick back, relax, and hold on to your wallets. The Humble Store introduced the June Tunes collection this week. Coming in with music and rhythm titles, the bundle begins with Wanderson, Everhood, and Onde in the first tier for $5. Going up a tier by paying $8 gets you three more games: Rhythm Fighter, One Btn Bosses, and Oddada. Lastly, Trombone Champ, DJMAX RESPECT V, and Ragnarock lead the final tier, which are yours for $10. Just yesterday, Humble also brought out the Serenity Forge Storyteller's Bundle. This carries 12 indie games inside it, including LISA the Joyful and LISA the Painful, Neversong, Death's Gambit, Smile for Me, Long Gone Days, and more, all split into three tiers of prices. Replacing Two Point Hospital, The Operator landed as the latest freebie on the Epic Games Store earlier this week. The 2024-released indie title has you taking the role of a new hire at the Federal Department of Intelligence (FDI). Here you have to analyze evidence, fact-check, and try to solve a streak of mysterious crimes using the agency's advanced investigative software. However, as the story progresses, a conspiracy is revealed that paints the FDI in a different light. The Operator giveaway on the Epic Games Store is slated to last until June 26. On the same day, Sable will become the next freebie in the promotion. Free Events If you're looking to try out some games over the weekend without opening your wallet, there are three games having free weekend offers right now. Starting off, Paradox is offering its grand strategy experience, Victoria 3, to try out. The title has a much higher focus on state management than war and roleplaying compared to the company's other games. If that's too much of a tough start, Len's Island is temporarily free-to-play now too. This is a top-down perspective survival game with support for up to eight players in co-op, with combat, farming, dungeon diving, and other elements being included. Lastly, Dead by Daylight should be the most familiar to most. The multiplayer four-versus-one asymmetric survival horror game has you assuming the roles of survivors or the killer to see who can come out on top. Big Deals With the Steam Summer Sale only being days away, most publishers and developers are laying low to prepare for the big event. Still, we found quite a few games having some attractive discounts. Here's our hand-picked big deals list for this weekend: Red Dead Redemption – $29.99 on Steam Mount & Blade II: Bannerlord – $24.99 on Steam Timberborn – $24.49 on Steam BERSERK and the Band of the Hawk – $23.99 on Steam Wo Long: Fallen Dynasty – $23.99 on Steam Disney Epic Mickey: Rebrushed – $23.99 on Steam Jagged Alliance 3 – $22.49 on Steam [NINJA GAIDEN: Master Collection] NINJA GAIDEN Σ2 – $19.99 on Steam Alone in the Dark – $19.99 on Steam Last Train Home – $19.99 on Steam Len's Island – $19.49 on Steam Nightingale – $17.99 on Steam DYNASTY WARRIORS 8: Xtreme Legends Complete Edition – $16.99 on Steam Mortal Kombat 1 – $16.49 on Steam SOMA – $14.99 on Steam Victoria 3 – $14.99 on Steam Trepang2 – $14.99 on Steam Blasphemous 2 – $14.99 on Steam Wreckfest – $14.99 on Steam Expeditions: Rome – $14.84 on Steam EA SPORTS FC 25 – $13.99 on Steam STAR WARS Jedi: Survivor – $13.99 on Steam DRAGON BALL Z: KAKAROT – $12.99 on Gamesplanet Amnesia: The Bunker – $12.49 on Steam DREDGE – $12.49 on Steam Dead Space – $11.99 on Steam DAVE THE DIVER – $11.99 on Steam WILD HEARTS – $10.49 on Steam It Takes Two – $9.99 on Steam Dragon Age Inquisition – $9.99 on Steam Haven – $9.99 on Steam Hellboy Web of Wyrd – $9.99 on Steam Nova Lands – $9.99 on Steam BIOMUTANT – $9.99 on Steam Destroy All Humans! 2 - Reprobed – $9.99 on Steam Ghostrunner 2 – $9.99 on Steam Need for Speed Unbound – $9.79 on Steam Call of the Wild: The Angler – $8.99 on Steam DEAD OR ALIVE 6 – $8.99 on Steam Operation: Tango – $8.99 on Steam Katana ZERO – $8.99 on Steam Dead by Daylight – $7.99 on Steam Killer Frequency – $7.49 on Steam Nioh: Complete Edition – $7.49 on Steam Overcooked! 2 – $6.24 on Steam A Way Out – $5.99 on Steam Mass Effect Legendary Edition – $5.99 on Steam Darksiders Genesis – $5.99 on Steam Mortal Kombat 11 – $4.99 on Steam Titanfall 2 – $4.49 on Steam Golf With Your Friends – $4.49 on Steam STAR WARS Battlefront II – $3.99 on Steam Yoku's Island Express – $3.99 on Steam theHunter: Call of the Wild – $3.99 on Steam RoboCop: Rogue City – $3.74 on Fanatical Battlefield 2042 – $2.99 on Steam Road Redemption – $2.99 on Steam Shadow Warrior 2 – $2.99 on Steam Battlefield V – $2.49 on Steam Ultimate Fishing Simulator – $1.99 on Steam DRM-free Specials The GOG store has already kicked off its own summer sale, putting thousands of DRM-free games on sale. Here are some highlights: Cyberpunk 2077 - $23.99 on GOG God of War - $19.99 on GOG Fallout 4: Game of the Year Edition - $15.99 on GOG Fallout 4: Game of the Year Edition - $15.99 on GOG Dino Crisis Bundle - $15.29 on GOG Devil May Cry HD Collection & 4SE Bundle - $14.84 on GOG The Witcher 3: Wild Hunt - Complete Edition - $9.99 on GOG Vampire: The Masquerade - Bloodlines - $9.99 on GOG SPORE Collection - $7.49 on GOG Papers, Please - $4.99 on GOG Terraria - $4.99 on GOG SWAT 4: Gold Edition - $4.99 on GOG DOOM (2016) - $3.99 on GOG DOOM 3 - $3.99 on GOG CrossCode - $3.99 on GOG Mad Max - $2.99 on GOG Heroes of Might and Magic 3: Complete - $2.49 on GOG Heroes of Might and Magic 4: Complete - $2.49 on GOG World in Conflict: Complete Edition - $2.49 on GOG Alan Wake - $1.49 on GOG Mortal Kombat 1+2+3 - $1.49 on GOG RollerCoaster Tycoon Deluxe - $1.19 on GOG Keep in mind that availability and pricing for some deals could vary depending on the region. That's it for our pick of this weekend's PC game deals, and hopefully, some of you have enough self-restraint not to keep adding to your ever-growing backlogs. As always, there are an enormous number of other deals ready and waiting all over the interwebs, as well as on services you may already subscribe to if you comb through them, so keep your eyes open for those, and have a great weekend.
    • Is there a 'recovery' settings option in Settings? The one where we can rollback to a previous restore point. I find it very useful if there is some issue and I have to rollback to the last stable point.
    • Google brings Gemini to all Workspace for Education subscribers by David Uzondu Google has announced that its Gemini app is now accessible to all Google Workspace for Education users, regardless of age. This brings the company's generative AI directly into the suite of tools used by millions of students and teachers. The Workspace for Education platform, if you did not know, already provides a massive suite of tools like Classroom, Docs, and Drive, which are designed to work together in a school setting. Naturally, the first question on any administrator's mind is what the company plans to do with student data. Google states that Gemini usage for these accounts falls under the Workspace for Education Terms of Service. This agreement includes "enterprise-grade data protections" and a promise that user data is not reviewed by anyone or used to train the company's AI models. It also maintains compliance with regulations like FERPA and COPPA, which are fundamental requirements for any technology operating in United States schools. The experience is not one-size-fits-all, particularly for younger students. Users under the age of 18 will get a more restricted version of the app, with stricter content filters to prevent inappropriate responses and a dedicated onboarding process to teach AI literacy. To reduce the likelihood of hallucinations, the first time a younger user asks a fact-based question, a double-check feature that validates the answer using Google Search runs automatically. For educators and older students, the AI can be used to brainstorm ideas, create lesson plans, and get feedback on work. The entire service is powered by what Google calls LearnLM, a family of its AI models supposedly fine-tuned for educational purposes. Access is not mandatory, as administrators can still control which users or groups can use the Gemini app through their admin console. This rollout applies to institutions using the free Education Fundamentals, the security-focused Standard, and the feature-rich Plus editions, making it widely available immediately.
  • Recent Achievements

    • Contributor
      GravityDead went up a rank
      Contributor
    • Week One Done
      BlakeBringer earned a badge
      Week One Done
    • Week One Done
      Helen Shafer earned a badge
      Week One Done
    • First Post
      emptyother earned a badge
      First Post
    • Week One Done
      Crunchy6 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      662
    2. 2
      ATLien_0
      269
    3. 3
      Michael Scrip
      236
    4. 4
      Steven P.
      164
    5. 5
      +FloatingFatMan
      155
  • Tell a friend

    Love Neowin? Tell a friend!