Slashdot Mirror
Alternatives to MS SQL Server for Dynamic Content Website?
Cindy asks: "My current employer has a handful of websites, which are massive and messy entanglement of ASP on IIS with MS SQL storing the dynamic content. As the company scaled down to only 1 full-time temp (me) in IS and a sales manager overseeing servers + managing web sites, the company would like to trim down behind the back. More specifically, they would like to let go of the use of SQL server altogether. I've used Zope before, but I'm not sure how well it works on Windows. Then there's ColdFusion, but I don't know anything about it. What other choices do I have?"
"The replacement has the following requirements:
- Must run on Windows (they're a Microsoft reseller after all)
- Stable, mature, secure for corporate strength (over 10 product categories, each with 8-10 products)
- Easy to learn, easy to use, and easy to maintain for someone who is comfortable with server maintenance and website design, but not too knowledgeable. I'll leave the company by January
- Not too much programming involved. HTML and ASP/PHP-ish are OK."
1. How much do you need to change the current set-up?
As one full-time temp, do you really have the personpower to re-write or re-implement everything, probably temporarily breaking things in the meanwhile? You'll be a wreck.
Why not leave it?
2. Licensing.
Tell us about how much you're paying for the different licensing of the MS server components you use. Maybe a libre solution might make more sense? Could you argue that in exchange for cutting out the licensing costs, you be given a few other temp team members to work with?
I think we really need more information before we can tell you what's best for your particular circumstances.
One more thing: Cold Fusion is soooo 90's.
And based on the content of this ask slashdot, it's you.
You compare Zope to SQL Server. Zope is an applications server. SQL Server is an RDBMS, a relational database. You can't replace SQL Server with Zope. Zope can use SQL Server. Since you've already licensed the expensive (and, in my opinion, EXCELLENT) SQL Server, why not continue to use it? If you want to use Zope instead of ASP, go ahead, but what makes you think it's going to be any easier to maintain than what you've got now? Or rather, will the headache of converting to Zope (or whatever) be worth the end result? Could it be that your current setup is "a messy entanglement" because of the way it was written, and not due to the tools you are using?
Perhaps you should hire a consultant to look over what you've got and help you figure out the best solution. It's hard to make a good recommendation when we don't know WHY your current situation is so entangled, or how hard it's going to be to untangle it.
"And like that
No, this is the perfect opportunity for subversion. Your rudeness to the question is completely unwarented. The open source community is going to have to find ways to force it's way onto the beachheads patrolled by such pointy haired MS lovers. This is a perfect case study of the real world obstacles that will be encountered.
If you think that you can just turn your back whenever a "goofy restriction" is in place, you are dooming the world to MS dominance.
to help a company that funds a company that is actively hostile to the members of this community.
What community is that? I'm a Slashdot reader, and I use Microsoft products all the time.
Not everyone on here is an anti-Microsoft zealot. (I'd wager the majority reading this site are accessing it from a Windows computer.)
"And like that
(Based on the fact that I've been in this position before and chose the wrong path, I offer this advice.)
First, given the lack of IT resources, you should be extremely wary of switching to a new technology (such as Zope). When you leave in January, there's no guarantee that anyone will understand Zope and it's likely that it won't be stable (or scalable). You may leave the company in a worse position than it is now.
Instead, I would offer two alternatives that could leave you in a more stable position:
Hope this helps.
-Peter
Anything else you get will require not only a lot of work to get running, but ongoing maintenence that it sounds like you can't do at this point.
what are you trying to accomplish? save money on licences? consolidate hardware? ease management? all of these motives lead to asp/sql server.
now, if you wanted security, flexibility, scalability, or performance, move away from asp/sql server.
There aint no pancake so thin it doesn't have two sides.
i don't mean to be rude but you've chosen to work at what i'd consider to be an unethical company.
How do you know what company she works for? She doesn't say in her submission. Do you know this submitter?
For sake of argument, let's just assume you don't. For sake of argument, let's just assume that you keyed in on the words "Microsoft reseller" and let fly with the spit and invective. Let's just assume that, shall we?
You ignorant, arrogant bastard. How dare you jump to conclusions about this poor person's company based solely on two words in an "Ask Slashdot?" You wanna talk about "actively hostile?" How's this for "actively hostile?" You, Kevin, give the community of computer hobbyists and open source advocates a bad name, and that's saying something. People wonder why Linux and open-source software in general are having trouble gaining acceptance in the market. This post of yours is an excellent example of why this is so. For every generous and helpful soul out there in the community, there's some arrogant little shit like you telling people to "go fuck off" when they ask for help.
Bite me, Kevin Lyda.
Oh, one more thing. You're not e.e. cummings, you know. Learn to use a fucking shift key. Asshole.
Whew. That felt good. Some people just needs flamin', you know?
I write in my journal
I'll tell you what I told Kevin-- only without using so much profanity, because this kind of response from you seems out of character with your usual posts; I'm extending the benefit of the doubt here and assuming that you happened to be an asshole in this instance, but that you're not usually an asshole.
This kind of attitude and a stance of open-source advocacy are incompatible. When using, or even thinking of using, open-source software, one has nowhere to turn but to the community itself for advice and help. When someone does that, it's critically important that the members of the community not be assholes. This kind of behavior just shatters whatever tiny grains of credibility the community of hobbyists and hackers has managed to accumulate over the years.
In other words, take your mama's advice. If you can't say something nice, shut the fuck up.
I write in my journal
Why go to the hassle of replacing something that you already have paid for and works well?
SQL server is easier to set up and maintain than many other Database software. Why do you want to replace it?
That's three. How many flames of the submitter are we going to see in this article? I was surprised at the first one, and disappointed by the second. Reading this, I'm starting to think that maybe there's a seedy underbelly to "the community" after all. Between you and that Kevin guy who complained about people trying to "spooge off of our work" (that cracked me up), I'm really beginning to understand why open source has the reputation it does in so many circles.
Probably the best thing for "the community" in this instance is for all y'all Microsoft-haters to learn when to keep your pie holes shut and just play nice with the other kids.
I write in my journal
i have nothing against other closed source software publishers like oracle, sun, compaq or apple. but then that's because they are not actively targeting my hobby, my livelihood and the hobbies/livelihoods of my friends. they do compete, but not in an agressive and frequently unethical manner
Yeah right. Oracle, Sun, Compaq, IBM and Apple would attack you in a heartbeat if they thought it would improve their bottom line.
It wasn't that long ago when Apple and IBM were the competition-crushing-FUDing-"It will only run on Apple Hardware" behemoth, and Microsoft was the rebeleous start up.
"Can of worms? The can is open... the worms are everywhere."
Not everyone on here is an anti-Microsoft zealot. (I'd wager the majority reading this site are accessing it from a Windows computer.)
Too true! I've come to the conclusion that there is no moral high ground to be had anymore in IT. It seems like every technology camp is intent on demeaning everyone else because they believe themselves to be superior. It's just another form of primitive tribalism where each tribe attempts to propagate itself through the zealotry of its constituency. The relative merits of each style of development and technology philosophy become lost and almost irrelevant in the cacophony of arrogance. It's getting very old...
The bottom line is that I'm going to implement the best tool for the job for a customer using whatever vendor makes the most sense. When a given vendor becomes too much of a pain in the ass, I'll move on to the next, and so on.
My viewpoint leads me to believe that Microsoft, OSS, IBM, and a few others will be around a long time to come. Some other vendors (Sun, Apple, etc) will be too much of a pain to bother with, and they will remain in their respective niche corners. Some of them may die entirely (possibly Sun, among others), and some may even transcend niche status (possibly Apple, among others). We'll see.
Please mod this post only if you think others should/n't read this. I have enough ego^H^H^Hkarma. Thanks!