Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Unanswered: Will the same MySql schema work in SQL or Oracle DB? Or we will have to create a new

    Will the same MySql schema work in SQL or Oracle DB? Or we will have to create a new DB schema?


  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you might have to change some of the datatypes if you've used any mysql proprietary features such as ENUM
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2012
    Posts
    2
    only we can change ENUM proprietary? or any thing else? please explain in detail. my client need that export the full DB from MySql and import it to SQL or ORACLE. is it possible?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    anything else? yes, plenty

    Comparison of relational database management systems - Wikipedia, the free encyclopedia

    Comparison of different SQL implementations

    Datatypes by George Hernandez

    you will have to analyze your mysql schema very carefully to see what datatypes you're using
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Exporting the schema and data is one thing but you also need to make sure that the application will connect to the new database.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

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
  •