SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Uruguay
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    from mssql to mysql

    Hi
    I have got a .bak file from mssql
    Can I pass it to mysql?
    How do I do it?

    Alvaro

  2. #2
    SitePoint Wizard silver trophy KLB's Avatar
    Join Date
    Nov 2003
    Location
    Maine USA
    Posts
    3,781
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Probably not. For instance MySQL does not support stored views plus the entire security regime is different. A better bet would be to use Enterprise manager to SQL that contained create statements for all of the tables and then use an ODBC connection to transfer the data from MSSQL to MySQL. This would at least allow you to transfer the data from one to the other.
    Ken Barbalace: EnvironmentalChemistry.com (Blog, Careers)
    InternetSAR.org
    Volunteers Assist Search and Rescue via Internet
    My Firefox Theme: Classic Compact
    Based onFirefox's default theme but uses much less window space

  3. #3
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Uruguay
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what you mean "Enterprise manager" ?

  4. #4
    SitePoint Wizard silver trophy KLB's Avatar
    Join Date
    Nov 2003
    Location
    Maine USA
    Posts
    3,781
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Enterprise Manager is the software that comes with MS-SQL server that allows you to control and manage MS-SQL. If you have MS-SQL, you have Enterprise Manager. If you are using a website host who uses MS-SQL, you probably don't have Enterprise Manager. If this is the case, and your database isn't too complex, you can manually recreate your tables in MySQL and then use an ODBC connection to allow you to transfer data from the MS-SQL database to the MySQL database.
    Ken Barbalace: EnvironmentalChemistry.com (Blog, Careers)
    InternetSAR.org
    Volunteers Assist Search and Rescue via Internet
    My Firefox Theme: Classic Compact
    Based onFirefox's default theme but uses much less window space


Bookmarks

Posting Permissions

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