473,320 Members | 2,041 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Multiple DBMS Support

I am in the process of designing a windows application that must support
multiple DBMS (MS Access, SQL Server, Oracle, etc.). The user will be able
to open, create, and save as from the file menu. I am contemplating using an
XML schema to define the database structure. Is there a resource (book,
white paper, etc.) that describes "best practices" (ideally with examples)
for this type of functionality?

--
Mary White

Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...neral/200609/1

Sep 6 '06 #1
1 1080
Hi Mary

I don't know of any best practices etc (although you may want to look
on the Microsoft 'Patterns and Practices' site as this has a lot of
useful info) but one suggestion I'd make (and apologies if it's
obvious) is to split out your data access layer so you can effectively
have one DAL for each supported DB type and can switch between them as
necessary.

As I say, apologies if I'm trying to teach you to suck eggs here - just
thought I'd chip in with something.

Cheers
Martin

maryewhite via DotNetMonster.com wrote:
I am in the process of designing a windows application that must support
multiple DBMS (MS Access, SQL Server, Oracle, etc.). The user will be able
to open, create, and save as from the file menu. I am contemplating using an
XML schema to define the database structure. Is there a resource (book,
white paper, etc.) that describes "best practices" (ideally with examples)
for this type of functionality?

--
Mary White

Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...neral/200609/1
Sep 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Albretch | last post by:
.. Can you define the Character Set for particular tables instead of databases? . Which DBMSs would let you do that? . How do you store in a DBMS i18n'ed users' from input, coming over the web...
5
by: Bill | last post by:
I have a book cataloge where I have an author id linked up to the book. However, I'm finding that some books have mulitple authors, and I'm wondering if there is a way to add more than one id to...
1
by: walt | last post by:
A few years ago I wrote an active-X server to maintain a single connection to a file .mdb from multiple apps on same PC because I was having to many database curptions. Should I use the same...
0
by: Tedmond | last post by:
Dear all, Does ADO.NET support VAX Aplha DBMS? And How? Thanks for any help! Tedmond
3
by: news.bahnhofbredband.se | last post by:
Some time ago I was working with DB2/400 - and one of the most appreciated features was the concept logical files - a bit more than views in that they maintained an access path. That is it...
2
by: Diego | last post by:
Hi everybody! I'm using DB2 PE v8.2.3 for linux. I've defined a database with the following schema: ANNOTATION(ID,AUTHOR,TEXT) ANNOTATION_BOOK(ANNOTATION_ID,OBJECT_ID)...
1
by: Tonny Iversen | last post by:
Hello. I haven't used NetBeans yet and I haven't programmed much Java (I've programmed more in C++), but I have a question: Can I get a data consistancy guarantee when writing to a file from Java...
12
by: leiw | last post by:
Hello, My company want to use database for ERP, any website to discuss DBMS advantage and disadvantage ? or someone post to here for references ? Thanks
8
AmberJain
by: AmberJain | last post by:
Hello, My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.