Sunday, September 07, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Plug-in and Platform Forums  MS SQL Server Database  Importing Exist...
 Re: Importing Existing SugarCRM Data
 
support
1887 posts
1st
Joined
1/3/2006
Re: Importing Existing SugarCRM Data
Posted: 21 Apr 08 5:54 PM

I've done some research and there is no easy way to migrate an existing database to SplendidCRM.  The problem is that SugarCRM uses varchar(36) for its primary keys and we use uniqueidentifiers.  It is possible to convert the IDs to uniqueidentifiers, but all index and keys would need to be dropped before the conversion.

Your best bet is to use the MySQL utilities to dump an XML of the entire database.  Then you can import the entire database into SplendidCRM using the Import Database admin tool. 

 
support
1887 posts
1st
Joined
1/3/2006
Re: Importing Existing SugarCRM Data
Posted: 22 Apr 08 10:35 AM Modified By support on 4/22/2008 10:36:36 AM)

We have made progress automating the migration of SugarCRM to SplendidCRM.  We still have a little more work to go, but here are some of the steps we follow:

  1. Drop all deafult constraints
  2. Drop all indexs.
  3. Drop all foreign keys.
  4. Drop all primary keys.
  5. Convert all IDs from varchar(36) to uniqueidentifiers.
  6. Convert all varchar fields to nvarchar fields.
  7. Convert all text fields to ntext fields.
  8. Restore all primary keys.
  9. Restore all foreign keys.
  10. Restore all indexes.
  11. Restore all default constraints.
  12. Add missing auditing fields to all tables (i.e. CREATED_BY, DATED_ENTERED, MODIFIED_USER_ID).
  13. Add fields that were dropped in SugarCRM.

If you would like to zip your database and sent it to our support staff, they would be happy to work with you on the migration.

 
 Page 2 of 2
NextPreviousNo Rating
Previous12 
  Plug-in and Platform Forums  MS SQL Server Database  Importing Exist...
Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.