Migration of Databases – An XML Approach

XML Database Migration is a project of migrating the existing databases into XML format. Conversion of databases to XML file format, the databases like Ms-Access, Oracle and MS-SQL, MySQL connects in the network or the oracle in the personal computer can be connected for the generation of XML code. Let us consider, user runs a firm with three companies with different database’s respectively. User planned to mingle the entire database’s of the firm in to a single database. The user wants to migrate the entire database in to a single database. Migration of a database to another database is a huge process and a complex one. In such case our project can be used as we are converting the entire database …show more content…

PROPOSED SYSTEM
XML Migration is project to convert the existing Database like Oracle and MSAccess into the XML database. The XML is a text formatted flat file, so this project has an ability to store any kind of data from the application system. On using the xml as a backend we reduce the memory occupied in net and there is no need to pay amount separately for XML database as it is file and consumes less memory. XML has more advantages over other databases.
The XML has the ability to process on any platform, since it is platfor independent we can use it in any operating system. Apart from this no proxy server or firewall can restrict xml formatted data’s. Here maintenance is very easy as it is a file and consumes very less memory. Previously in database maintenance is a major task and cost paid separately. Many databases are not supported in different platforms but XML file format supports different platforms like Linux, Windows etc., As .NET transfers data in the form of XML formatted data only. As this is a major advantage to us in converting to XML. XML flat file format is used as an intermediate for the Database conversions.

Software Requirements:

Front End:
.NET 2008 with ASP, C#.0 or above

Back End:
MySQL Server 2000, Oracle 8i, MySQL, MS-Access

Hardware Requirements:
PC Processor above 500 MHz with Windows 2000/XP/Vista/7
RAM – 128 MB and above
HDD – 10 GB and