Ah yes, but that is not always possible in the case of customers. Some people are content with stuff that works, over total reinstallation of their software, just because the totally uninteresting piece of technology that drives their app, has changed.
Brainwash the customers, provide a new installer with conversion script. This should get them over the SQL more easily.
I had a customer once who insisted on using Access as the backend. This way he could change the data if the application did something wrong. I had a spontanious urge to hit him on the head when I heard his plans.
What about weapons of mass-construction? "What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
I guess many people voted for Access even if they actually meant the Jet Database. I think it makes a huge difference if I'm developing for Access or if I use Jet databases.
As for me, I'm not the one who says Jet is bad in general. If you use it in the right place its a great and straightforward data storage. Sure, Jet is not designed to be accessed by many user at the same time, but so aren't .xml, .doc, .xls and whatever files. So why not using it?
"All languages allow you to write crap code, VB just makes it easier (IMO)." Michael P Butler
I had a vote for Access because we use the Jet database, not the Access front-end, and it was the closest option I could find listed. We use them for local data stores for a distributed application that runs on 100's of user's desktops. However, we are planning on migrating away from Jet and replacing that with SQL Server Compact Edition. It's been a good tool. I have had no problems with using it simply for a data store. We are only moving away from it because Microsoft has dictated that we do.
Couple of reasons you might use Access:
- easy to grab a full backup snapshot from the web host
- some web hosts overcharge for sql server, and you might just need basic DB functionality
- a bit easier to publish your DB; just upload.
- is capable of running moderately busy sites. However if you start getting 2000+ user session per day you might start getting issues with concurrent writes to the Access DB.
But yeah, better to avoid access nowadays esp. if your site will potentially grow to become very busy (SQL 2005 Express is a good an alternative).
"For fifty bucks I'd put my face in their soup and blow." - George Costanza
CP article: SmartPager - a Flickr-style pager control with go-to-page popup layer.
It surprises me a bit that Oracle is not that popular.
We found out that SQL Server still lacks functionality that is present in Oracle, like e.g. consistent snapshot reading without locking the database.
In Oracle you can simply start a read-only translation, which will cause all subsequent queries to read from a snapshot without locking the database.
For our applications this is important since we need to load huge (and consistent) databases into memory in order to run simulations on it. Since other processes update the database at the same time, we don't want to lock the database to have this consistent view on it.
Apparently this functionality is standard in Oracle, while it can only be achieved in SQL Server by buying the very expensive Enterprise Edition (or at least I think this was the name).
Do some of you have this same problem or know a workaround for it on SQL Server?
I once worked in an Oracle only (and proud of it!) shop that was required by a major customer to investigate supporting SQL Server. We eventually moved to SQL Server, apart from cost (like the 50K DBAs) it was simply the time taken to do a database backup and the whole process that was involved in it. SQL Server was simpler, and a hell of a lot quicker to backup. Although having said that we probably had to resort to using those backups a bit more than we previously had to with Oracle (but you can't win em all).
Thanks for the suggestion.
The link doesn't seem to work, but I found the necessary information using Google.
It seems you are right: the snapshot isolation level seems to be present in all editions.
Thanks for the tip.
A cry breaks the early morning peace, as the sun rises over the green hilltops. The pale fog begins to be burnt off, showing the brilliant blue of the morning sky. Meanwhile, somewhere deep in Redmond, Steve Ballmer is crying out to the heavens, "F***ing Google!!!!!!"
¡El diablo está en mis pantalones! ¡Mire, mire!
Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)!
And with that, Paul closed his browser, sipped his herbal tea, fixed the flower in his hair, and smiled brightly at the multitude of cute, furry animals flocking around the grassy hillside where he sat coding Ruby on his Mac...
Last Visit: 31-Dec-99 19:00 Last Update: 27-Nov-21 16:54