in

Dotnetpanel Forums

Community support forums for DotNetPanel products
Dotnetpanel Forums » DotNetPanel » General Support » database migration?

database migration?

Last post 08-31-2009 2:51 AM by jean3167. 9 replies.
Page 1 of 1 (10 items)
Sort Posts: Previous Next

  • 08-16-2009 11:44 PM

    database migration?

    Reply Contact

     On my old system I have few customers who are using ms sql 2000 and mysql 4 databases Now on new setup there is sql2005 and mysql5. How do i migrate these databases to new host and new version. Can anyone please guide me on it?

    Windows Server 2008
    DotNetPanel 2.8.7
    SmarterMail 5.5 Enterprise
    MS SQL 2005/2008 Enterprise
    IIS7
    SimpleDNS
    Filezilla
    Google Analytic

  • 08-17-2009 3:00 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: database migration?

    Reply Contact

    If its really a few customers them why not backup DBs on MSSQL 2000 and MySQL and restore them respectively on SQL 2005 an MySQL 5.

    Thanks

     

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

  • 08-17-2009 3:17 AM In reply to

    Re: database migration?

    Reply Contact

    you mean take backup from old dnp and restore it to new dnp.  

    Windows Server 2008
    DotNetPanel 2.8.7
    SmarterMail 5.5 Enterprise
    MS SQL 2005/2008 Enterprise
    IIS7
    SimpleDNS
    Filezilla
    Google Analytic

  • 08-17-2009 3:38 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: database migration?

    Reply Contact

    Yes .. or you can backup/dump db directly and restore..

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

  • 08-17-2009 3:45 AM In reply to

    Re: database migration?

    Reply Contact

    Thanks i am trying it.

    Windows Server 2008
    DotNetPanel 2.8.7
    SmarterMail 5.5 Enterprise
    MS SQL 2005/2008 Enterprise
    IIS7
    SimpleDNS
    Filezilla
    Google Analytic

  • 08-17-2009 4:20 AM In reply to

    Re: database migration?

    Reply Contact

    there is no restore option for mysql!

    Windows Server 2008
    DotNetPanel 2.8.7
    SmarterMail 5.5 Enterprise
    MS SQL 2005/2008 Enterprise
    IIS7
    SimpleDNS
    Filezilla
    Google Analytic

  • 08-17-2009 4:40 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: database migration?

    Reply Contact

    You can try to restore using phpMyAdmin or mySQL client like MySQL Front or HeidiSQL.

     

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

  • 08-25-2009 6:31 AM In reply to

    Re: database migration?

    Reply Contact

    Data loader can help u,it can migrate almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv  loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search.


    Download Free : http://www.dbload.com

  • 08-28-2009 3:13 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: database migration?

    Reply Contact

    Thanks.. Will look into it.

     

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

  • 08-31-2009 2:51 AM In reply to

    Re: database migration?

    Reply Contact

    Here is a tool to convert MSSQL to MYSQL database. That i found on google search it this converter can do migrate any data try and tel me is that worth or not.
Page 1 of 1 (10 items)
Powered by Community Server (Commercial Edition), by Telligent Systems