Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Lightbulb xml to other databases like access, sql, mysql, oracle

    Hi, I am bose.

    I m havin a doubt. Whether we can convert a xml form of data to any other databases we want.
    Suppose, I am havin all my data in mysql... I am goin to host my site. The hoster s not providin support for mysql. Can i convert the mysql database to ready to use oracle or sql server database????


  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Yes it is possible to migrate to Oracle or SQL Server. There are big differences between those products so you will almost certainly have to rewrite some of your code and make changes to data types in your database. Probably the easiest way to migrate the data would be to use an integration tool like SQL Server Integration Services with MySQL as the source and the new DBMS as the target.

    Alternatively you could find a different hosting company that does support MySQL.

    Not sure why XML is relevant in your question. I don't think putting the data into XML will help you switch database platforms.

  3. #3
    Join Date
    Jan 2010
    Posts
    2

    Red face xml to other database???

    can xml form of data be converted to any other databases ???

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If you have your data in mySQL, you understand mySQL and your new host will not support mySQL I would look for another host. I am amazed you managed to find a host that did not support mySQL to be honest.

    Converting from one database to another is not trivial. 9 times out of 10 the RDBMS choice will last the lifetime of the application.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by gbose View Post
    can xml form of data be converted to any other databases ???
    Yes. Provided you have the software tools to do it.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Look in to XSL.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •