Oracle Xpress Edition

Currently I am working on a project that require to use Oracle database. I have just download a free edition of Oracle Edition called the Xpress Edition. This will be my first time working on Oracle database, and is a bit new to 'stuff'. Previously, I was working with MS SQL2000, and recently there is a request to convert to Oracle. One of the reason being the client has a limit of MS SQL 2000 license but 'abdundance' Oracle client license. This sudden chance is going to add more work to me.
First I have to get familiar with Oracle Database Software, Oracle SQL Syntax, and then I have to convert the existing table from MS SQL to Oracle. Then I would need to know how to connect to the database from my .NET application. This is include some modication that is need on the data access part. All this mean more works. But it is also a chance to learn Oracle.
One thing I discovered with the Express edition of the Oracle as compare the MSSQL is the amount of Virtual memory and memory that the application taken out. It is 'huge' compare to MSSQL. Hmm ... I wonder if I would gonna to use the Oracle Express as part of package of my application. Need statistics on the impact of the database on OS, and need to find out if it will make OS 'slows' down. Well this will going to be another task to do.
Now ... back to work on the table conversion ...

About Me

I am a programmer specialize in Microsoft .NET programming. Most of my current programming center in WinForm Programming in C# language for desktop and devices. I have work with technologies like remoting, webservice, ADO.NET from the perspective of WinForm. I am not much of a web programmer, but currently exploring this area. I guess my skill set is a bit out-of-the current world of web-based application.

Nevertheless, my interest is in the area of software architecture and framework. Currently, I am working on a personal project to come out with reusable components and possible a software framework that I can based my future project on (or rather adapting what out there to customize to my needs). I have read book on framework design and software design pattern, and the more that I read the more interesting and complex the topic get.

Most of the applications that I created are used for tracking of items. In my projects, I have work with barcodes, RFID and Handheld Terminal that are used in warehouse and logistic environment for tracking of goods.

OK .. To be continue .. Need to get back to programming for now ...