Multiple RDBMS Support and the Factory Design Pattern

August, 2008 Update.
I added in SqlServerCE support (version 3.1 for desktop).
Now there is SqlServer, Access, Excel, Text and SqlServerCE.
SqlServerCE was a little tricky at first, but I got it running.
This is an early preview, and I don’t have alot of comments or explanation yet.
Download the code HERE (Right Click / Save As works best)
One of my first real jobs my company had to support multiple RDBMS (Relational Database Management Systems).
Sql Server 6.5, 7.0, Sybase, and Access/Jet (Although I don’t consider Access/Jet a real RDBMS).
Oh, the countless number of "IF gDataBaseType="Access" then" statements.  YUCK!
I had been advising people to use the Factory Pattern for multiple RDBMS support, but finally decided to author a demo.
You’ll need Sql Server 2000,2005 or 2008.  You don’t have to have those, but it helps.
Most important instruction.  Read the README.txt file before unzipping.
Again, read the README.txt file BEFORE unzipping.
I’ll followup with this at some point, but wanted to get the sneak preview out the door.

This entry was posted in Software Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s