Thursday, November 20, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Plug-in and Platform Forums  MS SQL Server Database  In-place migrat...
 In-place migration of a SugarCRM MS SQL database
 
dgoldman
9 posts
Joined
3/8/2007

In-place migration of a SugarCRM MS SQL database
Posted: 22 Sep 08 11:04 AM

I see in-place migration from SugarCRM listed as a new feature in 2.1; however, I did not see any documentation in the deployment guide or otherwise to successfully use this feature.  Also, I did not see anything in the administration page to import a SQL database.  I tried pointing to the the SugarCRM database in the configuration wizard, but that gave errors.  Can someone please point me in the right direction so we can begin using our sugar data with SplendidCRM?  Thank you.

-Dan

support
2094 posts
1st
Joined
1/3/2006

Re: In-place migration of a SugarCRM MS SQL database
Posted: 22 Sep 08 11:08 AM

First, make sure that you backup your existing database.  Our migration is dependent on the quality of your data, so there is the possibility of a migration failure.

To migrate SugarCRM on MS SQL, you simply need to install SplendidCRM on top of the database.  The SplendidCRM scripts will add all missing fields to all the tables that it uses.  It will also migrate non-GUID IDs to properly formatted GUID IDs.

We do not migrate SugarCRM screen layout customizations.

 

dgoldman
9 posts
Joined
3/8/2007

Re: In-place migration of a SugarCRM MS SQL database
Posted: 22 Sep 08 2:01 PM

Thanks for the response.  When configuring Splendid with our Sugar DB, after runing the stored procedures/scripts on the database, the configuration tool gives an error: vwLANGUAGES not found and then crashes.  Any suggestions?

support
2094 posts
1st
Joined
1/3/2006

Re: In-place migration of a SugarCRM MS SQL database
Posted: 22 Sep 08 3:29 PM

Is that the only error you get?  I would expect other errors before that one.

You might want to contact our support staff directly.  They may be able to convert the database for you.

dgoldman
9 posts
Joined
3/8/2007

Re: In-place migration of a SugarCRM MS SQL database
Posted: 22 Sep 08 4:08 PM
That is the first and final error I get.  Is there any possibility of a sugar database health utility that might uncover issuse with an existing database prior to conversion?  Who might I speak with on the support staff regaurding having this database converted?  It is our plan to move to the Professional version of SplendidCRM, however, a moderately painless conversion of our current database would be required.
  Plug-in and Platform Forums  MS SQL Server Database  In-place migrat...

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.