Results 1 to 3 of 3

Thread: mysql -> sql

  1. #1
    Meyer is offline Sugar Community Member
    Join Date
    Oct 2006
    Location
    south africa
    Posts
    646

    Default mysql -> sql

    My client started out on mysql, but has grown big and bought sql server. he wants to move to sql platform with sugar,

    how and what is the easiest safest way to merge his mysql data to sql? that includes reports workflows, the whole shebang

    cheers

    paul

  2. #2
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Default Re: mysql -> sql

    There are good web resources to help you do this.

    The key issue you will find is the date/time conversion. Mysql and MS SQL store it very differnetly.

    There is also extensive discussion in the Wiki about this.

    You may want to hire someone to help you. Let me know as I can help you with this.

    thanks Paris

  3. #3
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: mysql -> sql

    Hi, Paul

    You can find some tools in google which enable converting mysql to sql server.

    One example is that one:
    http://mysql-to-ms-sql-conversion.qarchive.org/

    Best regards.
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Query Failed: AND users.id = '1'::MySQL error 1064:
    By artco001 in forum Installation and Upgrade Help
    Replies: 63
    Last Post: 2009-05-07, 05:56 AM
  2. Replies: 1
    Last Post: 2008-02-22, 04:25 PM
  3. Replies: 5
    Last Post: 2007-11-13, 02:51 PM
  4. Huge backups -- normal?
    By Liam in forum Help
    Replies: 5
    Last Post: 2007-05-02, 05:36 AM

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
  •