Community
Showing results for 
Search instead for 
Do you mean 
Reply

can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

New Member
Posts: 3
Country: USA

can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

I have a client who has been running ACT 2007 because it worked fine for them.  Now that they are purchasing new computers with 64-bit versions of Windows, ACT 2007 will no longer install.  Is there a direct upgrade path from ACT 2007 to ACT 2012, or will I run into any issues converting the data to the new format?

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Hello joshsbwn,
You can update your 2007 database directly from 2007 to 2012 by opening it in the new version. You will be prompted to backup the database, then convert it.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

New Member
Posts: 7
Country: Netherlands

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

HI there, I have act 2007 and just installed Act 2012, how do I move my database from Act2007 to Act2012? thank you
I have tried opening it in new version but does not work,
Copper Elite Contributor
Posts: 260
Country: Australia

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Hi Stan

 

When opening a database from an older version of ACT it will automatically prompt you to upgrade the database for use with the new version.  When you say it doesn't work with the new version what do you mean exactly? 

Does ACT prompt you to upgrade your database?

And if so, does the upgrade process finish properly?  Or do you receive an error message?

If you are receiving an error message, what is the message?

Cherie Buttsworth
ACT! Certified Consultant
Simply PC
cherie@simplypc.com.au
New Member
Posts: 7
Country: Netherlands

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Thank you Cherie, Yes I do get an error message, here is what I get;

 

'Exceptions occurred while executing the database Schema Update Script.

 

Contact your Administrator for assistance.'
  
 here is the error details.

 

 

Changed database context to 'NedatabaseBGmanagementOct092012'.Setting Database Compatibility Level...  Local Datetime: 2012-10-10 14:24:13 Servername: STAN-PC\ACT7 Engine Edition: 4  Express Edition (64-bit) Product Version: 10.50.1600.1 (RTM) Server Collation: SQL_Latin1_General_CP1_CI_AS ------------------------------------------------------------------------------ Sync Enabled: False Sync Role: ------------------------------------------------------------------------------ Database: NedatabaseBGmanagementOct092012 Status: ONLINE Create Version: 661  Configuration option 'user instances enabled' changed from 0 to 0. Run the RECONFIGURE statement to install.-------------------------------------------------------------  Current Build: 09.00.0556.0000  Update Build: 14.1.97.0 ------------------------------------------------------------- Setting Database Auto_Shrink To OFF...---------------------------------------------------------------- Setting Previous Schema Values: 09.00.0556.0000 TO 14.1.97.0DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Dropping indexes and constraints starting... 2012-10-10 14:24:13 Disabling change tracking Dropping triggers, starting ... 2012-10-10 14:24:16 Dropping Tables, starting... 2012-10-10 14:24:16 Dropping table TBL_LOGONHISTORY Creating Tables, starting... 2012-10-10 14:24:16Creating Table TBL_LOGONHISTORY Adding calculated fields, starting... 2012-10-10 14:24:17 Altering table TBL_OPPORTUNITY (DAYSOPEN)Altering table TBL_PRODUCTSERVICE (DISCOUNTTYPE) Table modifications - Adds, Deletes, etc. 2012-10-10 14:24:17Altering table TBL_CONTACT_CONTACTModifying obsolete datatypes Object removals - procedures, views, etc. Setting Ctl_Abl_Connectortype Data...2012-10-10 14:24:19 Setting Ctl_Localstring Data...2012-10-10 14:24:19 Setting Syncsettype Data...2012-10-10 14:24:19 Setting Activity Priority Data...2012-10-10 14:24:19 Setting Eventlog Type Data...2012-10-10 14:24:19 Setting Folder Data...2012-10-10 14:24:19 Setting Preference Data...2012-10-10 14:24:19 Setting Role Data...2012-10-10 14:24:19 Setting SyncDbtype Data...2012-10-10 14:24:19 Setting Sysconstant Data...2012-10-10 14:24:19 Setting Sysdomain Data...2012-10-10 14:24:19 Setting Sysdatatypes...2012-10-10 14:24:19 Setting Featureset Data...2012-10-10 14:24:19 Setting Sysentity Data...2012-10-10 14:24:19 Setting Tbl_Syslocalcolumn Data...2012-10-10 14:24:19 Setting Sysoperator Data...2012-10-10 14:24:19 Setting Sysdomain Sysoperator Data...2012-10-10 14:24:19 Setting SystableDomain Data at 2012-10-10 14:24:19.590 Setting Sysvalue Data...2012-10-10 14:24:19 Setting Sysvalue Usage Data...2012-10-10 14:24:19 Setting Permission data at 2012-10-10 14:24:19 Setting Permission Depend Data...2012-10-10 14:24:19 Setting Historytype_Supergroup Data...2012-10-10 14:24:19 Setting Historytype_group Data...2012-10-10 14:24:19 Setting Historytype data...2012-10-10 14:24:19Creating views Creating functions and viewsCreating View VWX_USERCreating View VWX_TEAMCreating View VWX_RESOURCECreating View VWX_ACCESSORCreating View VWX_CONTACT_USER_ENUMCreating View VWX_GROUP_USER_ENUMCreating View VWX_COMPANY_USER_ENUMCreating View VWX_OPPORTUNITY_USER_ENUMCreating View VWX_WORKFLOWDEF_USER_ENUMCreating View VWX_PERMISSIONINFOCreating View VWX_ROLEINFOCreating View VWX_ROLE_PERMISSION_MATRIXCreating View VWX_USERPERMISSIONCreating view VWT_OPPORTUNITY_STAGE_PROCESSCreating view VWT_WORKFLOW_ARCHIVECreating view VWT_WORKFLOWDEF_ACCESSCreating view VWT_OPPORTUNITY_ACCESSCreating view VWT_COMPANY_ACCESSCreating view VWT_GROUP_ACCESSCreating View VWT_CONTACT_ACCESSCreating view VWT_SECONDARY_CONTACTCreating view VWT_COMPANY_BUSINESSLINKCreating view VWT_CONTACT_BUSINESSLINK Running DBRights... The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. The number of orphaned users fixed by updating users was 0. The number of orphaned users fixed by adding new logins and then updating users was 0. *** Setting rights on procedures...     Adding Constraints at 2012-10-10 14:24:23 ADDING CTL_ABL_FIELD_IS_READONLY_DEF ADDING CTL_ABL_FIELD_BUSINESS_STATIC_MAP_DEF ADDING CTL_DBCONFIG_ISCOPIED_DEF ADDING CTL_EVENTLOG_EVENTDATE_DEF ADDING CTL_EVENTLOG_SQLUSER_DEF ADDING CTL_EVENTLOGDETAIL_DETAILDATE_DEF ADDING CTL_OLEDBVIEW_OLEDBFUNCTION_ISPRIMARYFUNCTION_DEF ADDING CTL_SQLTRACE_STMTTIME_DEF ADDING CTL_SQLTRACE_SPID_DEF ADDING CTL_SYNCDBMAPINFO_ISREPLAY_DEF ADDING CTL_SYNCDBMAPINFO_NEXT_ADDSYNCROWID_DEF ADDING CTL_SYNCDBMAPINFO_NEXT_DELSYNCROWID_DEF ADDING CTL_SYNCDBMAPINFO_NEXT_UPDSENDDATE_DEF ADDING CTL_SYNCDBMAPINFO_HISTORY_ISREPLAY_DEF ADDING CTL_SYNCROW_UPDATECOLUMN_APPLYDATE_DEF ADDING CTL_USERSESSION_PING_TIME_DEF ADDING TBL_ACCESSOR_ACTIVITY_STATUSNUM_DEF ADDING TBL_ACCESSOR_DELEGATE_ROWSOURCE_DEF ADDING TBL_ACTIVITY_SOURCENUM_DEF ADDING TBL_ACTIVITY_ISEVENT_DEF ADDING TBL_ACTIVITY_ISDELETED_DEF ADDING TBL_ACTIVITY_TZ_BIAS_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_BIAS_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_BIAS_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_MONTH_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_DOW_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_DAY_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_HOUR_DEF ADDING TBL_ACTIVITY_TZ_DAYLIGHT_MINUTE_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_MONTH_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_DOW_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_DAY_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_HOUR_DEF ADDING TBL_ACTIVITY_TZ_STANDARD_MINUTE_DEF ADDING TBL_ACTIVITY_ISINVITATIONSENT_DEF ADDING TBL_ACTIVITYSERIESITEM_ANCHOROFFSETPERIOD_DEF ADDING TBL_COMPANY_ISPRIVATE_DEF ADDING TBL_COMPANY_HASSUBCOMPANY_DEF ADDING TBL_COMPANY_ACL_ROWSOURCE_DEF ADDING TBL_COMPANY_CONTACT_ROWSOURCE_DEF ADDING TBL_COMPANY_OPPORTUNITY_ISMEMBER_DEF ADDING TBL_COMPANYCONTACT_MAP_ISMANDATORY_DEF ADDING TBL_CONTACT_ACL_ROWSOURCE_DEF ADDING TBL_FEATURESET_ISCUSTOM_DEF ADDING TBL_GROUP_HASSUBGROUP_DEF ADDING TBL_GROUP_ACL_ROWSOURCE_DEF ADDING TBL_GROUP_OPPORTUNITY_ISMEMBER_DEF ADDING TBL_OPPORTUNITY_GROSSMARGINAMT_DEF ADDING TBL_OPPORTUNITY_WEIGHTEDAMT_DEF ADDING TBL_OPPORTUNITY_ACL_ROWSOURCE_DEF ADDING TBL_PERMISSION_TYPENUM_DEF ADDING TBL_PHONE_COUNTRYCODE_DEF ADDING TBL_PHONEMASK_ISACTIVE_DEF ADDING TBL_PICKLIST_ISCUSTOM_DEF ADDING TBL_PICKLIST_SYSCOLUMN_ISTYPEAHEAD_DEF ADDING TBL_PRODUCTSERVICE_DISCOUNTTYPENUM_DEF ADDING TBL_SERIALNUMBER_CREATEDATE_DEF ADDING TBL_SERIALNUMBER_CREATEUSERID_DEF ADDING TBL_SYNCDB_ISEXPIRED_DEF ADDING TBL_SYNCDB_EXPIREACTION_DEF ADDING TBL_SYNCDB_CONFLICTRULE1_DEF ADDING TBL_SYNCDB_EXPIREDAYS_DEF ADDING TBL_SYNCDB_CONFLICTRULE2_DEF ADDING TBL_SYNCDB_ISINCLUDEATTACH_DEF ADDING TBL_SYNCSET_TYPENUM_DEF ADDING TBL_SYNCSET_ISALLUSERSYNC_DEF ADDING TBL_SYSCOLUMN_SYNCTYPENUM_DEF ADDING TBL_SYSCOLUMN_ISRESIZEABLE_DEF ADDING TBL_SYSCOLUMN_ALLOWDATATYPECHANGE_DEF ADDING TBL_SYSCOLUMN_VALIDACCESSLEVELS_DEF ADDING TBL_SYSCOLUMN_OLEDBTYPENUM_DEF ADDING TBL_SYSENTITY_ISDISPLAYED_DEF ADDING TBL_SYSENTITY_ISDEFINEFIELD_DEF ADDING TBL_SYSENTITY_ISCUSTOM_DEF ADDING TBL_SYSENTITY_TYPENUM_DEF ADDING TBL_SYSENTITYRELATION_ISCUSTOM_DEF ADDING TBL_SYSENTITYRELATION_ROLETYPENUM_DEF ADDING TBL_SYSENTITYRELATION_HASCREATEEDIT_DEF ADDING TBL_SYSENTITYRELATION_HASDETAILS_DEF ADDING TBL_SYSTABLE_HASPHONEVIRTUALS_DEF ADDING TBL_SYSTABLE_HASEMAILVIRTUALS_DEF ADDING TBL_SYSTABLE_HASADDRESSVIRTUALS_DEF ADDING TBL_SYSTABLERELATION_RELATIONID_DEF ADDING TBL_TEAM_USER_ROWSOURCE_DEF ADDING TBL_USER_ISPWDNEVEREXPIRE_DEF ADDING TBL_USER_ISPWDCASESENSITIVE_DEF ADDING TBL_USER_ISVERIFIED_DEF ADDING TBL_USER_UTC_OFFSET_DEF ADDING TBL_USER_ISFORCEPWDCHG_DEF ADDING TBL_USER_ISALLOWPWDCHG_DEF ADDING TBL_USER_DEFAULT_ACL_ENTITYID_DEF ADDING TBL_WORKFLOW_QUERY_ISUNLOCKED_DEF ADDING TBL_WORKFLOW_ACL_ROWSOURCE_DEF ADDING CTL_EVENTLOGDETAIL_STATUSNUM_CHK ADDING CTL_SYNCDBMAP_SESSIONROW_STATUSNUM_CHK ADDING CTL_SYNCROW_FILE_ACTIONCODE_CHK ADDING TBL_ACCESSOR_TYPENUM_CHK ADDING TBL_ACCESSOR_STATUSNUM_CHK ADDING TBL_ACCESSOR_ACTIVITY_STATUSNUM_CHK ADDING TBL_ACCESSOR_DELEGATE_CALLEVEL_CHK ADDING TBL_ACCESSOR_DELEGATE_ROWSOURCE_CHK ADDING TBL_ACTIVITY_RECURPERIOD_CHK ADDING TBL_ACTIVITY_ISPRIVATE_CHK ADDING TBL_ACTIVITY_RECURMODIFIER_CHK ADDING TBL_ACTIVITY_RECURDAYTYPE_CHK ADDING TBL_ACTIVITY_RECURMONTH_CHK ADDING TBL_ACTIVITY_SOURCENUM_CHK ADDING TBL_COMPANY_ACL_ROWSOURCE_CHK ADDING TBL_COMPANY_CONTACT_ROWSOURCE_CHK ADDING TBL_CONTACT_TYPENUM_CHK ADDING TBL_CONTACT_ACL_ROWSOURCE_CHK ADDING TBL_GROUP_ACL_ROWSOURCE_CHK ADDING TBL_HISTORY_ISPRIVATE_CHK ADDING TBL_HISTORYTYPE_CLEARTYPENUM_CHK ADDING TBL_IMPORT_HISTORY_ACTIONTYPENUM_CHK ADDING TBL_LOGONHISTORY_STATUSNUM_CHK ADDING TBL_NOTE_ISPRIVATE_CHK ADDING TBL_OPPORTUNITY_STATUSNUM_CHK ADDING TBL_OPPORTUNITY_PROBABILITYPCT_CHK ADDING TBL_OPPORTUNITY_ACL_ROWSOURCE_CHK ADDING TBL_PERMISSION_TYPENUM_CHK ADDING TBL_PICKLIST_TYPENUM_CHK ADDING TBL_PRODUCTSERVICE_DISCTYPENUM_CHK ADDING TBL_RESOURCE_TYPENUM_CHK ADDING TBL_STAGE_PROBABILITYPCT_CHK ADDING TBL_SYNCDB_STATUSNUM_CHK ADDING TBL_SYNCDB_EXPIREDAYS_CHK ADDING TBL_SYNCDB_EXPIREACTION_CHK ADDING TBL_SYNCDB_CONFLICTRULE1_CHK ADDING TBL_SYNCDB_CONFLICTRULE2_CHK ADDING TBL_SYNCEXTENDEDDATA_EXTENDEDTYPENUM_CHK ADDING TBL_SYNCEXTENDEDDATA_NUMTYPE_CHK ADDING TBL_SYNCSUBSCRIPTION_SUBSTATUS_CHK ADDING TBL_SYNCSUBSCRIPTION_SUBSOURCE_CHK ADDING TBL_SYSCOLUMN_SYNCTYPENUM_CHK ADDING TBL_SYSCOLUMN_RECORDIDENTIFIER_CHK ADDING TBL_SYSCOLUMN_UPDATETYPE_CHK ADDING TBL_SYSCOLUMN_TYPENUM_CHK ADDING TBL_SYSCOLUMN_VALIDACCESSLEVELS_CHK ADDING TBL_SYSCOLUMN_ACL_ACCESSLEVEL ADDING TBL_SYSENTITY_TYPENUM_CHK ADDING TBL_SYSENTITYRELATION_FROM_CARDINALITY_CHK ADDING TBL_SYSENTITYRELATION_TO_CARDINALITY_CHK ADDING TBL_SYSTABLE_TYPENUM_CHK ADDING TBL_TABLEKEY_KEYTYPE_CHK ADDING TBL_WORKFLOW_ACL_ROWSOURCE_CHK Adding Indexes at 2012-10-10 14:24:24 Adding Primary Key for table CTL_OLEDBVIEW_JOINDATA Adding Primary Key for table CTL_SYSTABLEORDER Adding Primary Key for table TBL_ACTIVITYSERIESAPPLIED Adding Primary Key for table TBL_ATTACHMENT Adding Primary Key for table TBL_HISTORY Adding Primary Key for table TBL_LOGONHISTORY Adding Primary Key for table TBL_NOTE Adding Primary Key for table TBL_OPPORTUNITY Adding Primary Key for table TBL_USER_DEFAULT_ACL Setting Systable Metadata at 2012-10-10 14:24:30 Setting systable metadata for TBL_LOGONHISTORY.. Setting Sysentity_Systable Data...2012-10-10 14:24:30 Setting Column Metadata at 2012-10-10 14:24:47 Setting syscolumn metadata for ACTIVITYID on TBL_ACTIVITY Setting syscolumn metadata for ACTIVITYSERIESAPPLIEDID on TBL_ACTIVITY Setting syscolumn metadata for ACTIVITYTYPEID on TBL_ACTIVITY Setting syscolumn metadata for CREATEDATE on TBL_ACTIVITY Setting syscolumn metadata for CREATEUSERID on TBL_ACTIVITY Setting syscolumn metadata for CREATEUSERID_NAME on TBL_ACTIVITY Setting syscolumn metadata for DELETED_DATES on TBL_ACTIVITY Setting syscolumn metadata for DETAILS on TBL_ACTIVITY Setting syscolumn metadata for DURATION on TBL_ACTIVITY Setting syscolumn metadata for EDITDATE on TBL_ACTIVITY Setting syscolumn metadata for EDITUSERID on TBL_ACTIVITY Setting syscolumn metadata for EDITUSERID_NAME on TBL_ACTIVITY Setting syscolumn metadata for ENDTIME on TBL_ACTIVITY Setting syscolumn metadata for EXTERNALID on TBL_ACTIVITY Setting syscolumn metadata for ISDELETED on TBL_ACTIVITY Setting syscolumn metadata for ISEVENT on TBL_ACTIVITY Setting syscolumn metadata for ISINVITATIONSENT on TBL_ACTIVITY Setting syscolumn metadata for ISPRIVATE on TBL_ACTIVITY Setting syscolumn metadata for ISRECURENDLESS on TBL_ACTIVITY Setting syscolumn metadata for ISTIMELESS on TBL_ACTIVITY Setting syscolumn metadata for LOCATION on TBL_ACTIVITY Setting syscolumn metadata for MASTERACTIVITYID on TBL_ACTIVITY Setting syscolumn metadata for ORGANIZEUSERID on TBL_ACTIVITY Setting syscolumn metadata for ORGANIZEUSERID_NAME on TBL_ACTIVITY Setting syscolumn metadata for ORIGINALTIME on TBL_ACTIVITY Setting syscolumn metadata for PARENTACTIVITYID on TBL_ACTIVITY Setting syscolumn metadata for RECURDAY on TBL_ACTIVITY Setting syscolumn metadata for RECURDAYTYPE on TBL_ACTIVITY Setting syscolumn metadata for RECURENDDATE on TBL_ACTIVITY Setting syscolumn metadata for RECURFREQ on TBL_ACTIVITY Setting syscolumn metadata for RECURMODIFIER on TBL_ACTIVITY Setting syscolumn metadata for RECURMONTH on TBL_ACTIVITY Setting syscolumn metadata for RECURPERIOD on TBL_ACTIVITY Setting syscolumn metadata for RECURSOURCEACTIVITYID on TBL_ACTIVITY Setting syscolumn metadata for REGARDING on TBL_ACTIVITY Setting syscolumn metadata for SOURCENUM on TBL_ACTIVITY Setting syscolumn metadata for STARTTIME on TBL_ACTIVITY Setting syscolumn metadata for TZ_BIAS on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_BIAS on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_DAY on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_DOW on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_HOUR on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_MINUTE on TBL_ACTIVITY Setting syscolumn metadata for TZ_DAYLIGHT_MONTH on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_BIAS on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_DAY on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_DOW on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_HOUR on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_MINUTE on TBL_ACTIVITY Setting syscolumn metadata for TZ_STANDARD_MONTH on TBL_ACTIVITY Setting syscolumn metadata for WF_CONTEXTID on TBL_ACTIVITY Setting syscolumn metadata for WF_INSTANCEID on TBL_ACTIVITY Setting syscolumn metadata for APPLICATIONNAME on TBL_LOGONHISTORY Setting syscolumn metadata for APPLICATIONVERSION on TBL_LOGONHISTORY Setting syscolumn metadata for CLIENT_IPADDRESS on TBL_LOGONHISTORY Setting syscolumn metadata for CLIENT_MACHINE on TBL_LOGONHISTORY Setting syscolumn metadata for CLIENT_USERNAME on TBL_LOGONHISTORY Setting syscolumn metadata for DATABASENAME on TBL_LOGONHISTORY Setting syscolumn metadata for DATABASESERVER on TBL_LOGONHISTORY Setting syscolumn metadata for LOGOFFDATE on TBL_LOGONHISTORY Setting syscolumn metadata for LOGONDATE on TBL_LOGONHISTORY Setting syscolumn metadata for LOGONHISTORYID on TBL_LOGONHISTORY Setting syscolumn metadata for STATUSNUM on TBL_LOGONHISTORY Setting syscolumn metadata for USERID on TBL_LOGONHISTORY Setting Systablekey Metadata at 2012-10-10 14:24:48 Setting systablekey metadata for TBL_LOGONHISTORY_PK ... Setting systablekey metadata for TBL_LOGONHISTORY_IE1 ... Setting systablekey metadata for TBL_LOGONHISTORY_IF1 ... Starting Column Description inserts: Oct 10 2012  2:24PMCreating functions and viewsCreating View VRP_MYRECORDCreating View VWX_COLUMNINFOCreating View VWX_CALCCOLUMNINFOCreating View VWX_TABLEKEYINFOCreating View VWX_ENTITYINFOCreating View VWX_ENTITYTABLEINFOCreating View VWX_ENTITYRELATIONINFOCreating View VWX_PICKLISTINFOCreating View VWX_TABLEPAGESIZECreating View VWX_ADDRESSTYPESCreating View VWX_COLUMNINFOCreating View VWX_PHONETYPESCreating View VWX_ENTITY_TABLE_PAGESIZECreating View VWX_COMPANYCONTACT_MAPCreating View VWX_ATTACHMENT_ASSOCIATIONSCreating View VWX_MYDELEGATESCreating View VWX_DELEGATETOCreating View VWX_OLEDBVIEW_COLUMNINFOCreating View VWX_DOMAINOPERATORSCreating View VWX_DOMAINOPERATORVALUESCreating View VWX_SYNCROW_ADDCreating View VWX_SYNCROW_DELETECreating View VWX_SYNCROW_FILECreating View VWX_SYNCROW_UPDATECreating View VWX_SYNCROW_EXCEPTIONCreating View VWX_SYNC_TABLESCreating View VWX_SYNC_COLUMNSCreating View VWX_SYNC_SYNCSETACCESSORSCreating View VWX_SYNCDBCreating View VWX_SYNCAPPLOCKCreating View VWX_SYNCDB_DEVICETABLECreating View VWX_SYNCDBMAPINFO_ALLCreating View VWX_DBLOCKINFOCreating View VWX_EVENTLOGINFOCreating View VWX_GROUP_ALPHAHIERSORTCreating View VWX_COMPANY_ALPHAHIERSORTCreating View VWX_BACKUPAPPLOCKCreating View VWT_OPPORTUNITY_ASSOCIATED_DATACreating View VWX_BI_OpportunityView_FullCreating View VWX_BI_HistoryView_Full Creating procedures  The module 'PRC_REPORT_REBUILD_OLEDBOBJECTS' depends on the missing object 'dbo.PRC_UPD_USER_COLUMNACCESS'. The module will still be created; however, it cannot run successfully until the object exists. *********** Schema Update failed ************** *********** Exception message follows ********* System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.    at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

 

Schema Update failed.


 
 


Copper Elite Contributor
Posts: 260
Country: Australia

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Do you know which version of Sage ACT 2012 you have installed?  From the file menu choose About ACT, you don't need a database open to do this.

If you are running 2012 version 14.0.572.0 then please go to the following KB article and download & install SP1, then try upgrading your database again.

If you are already running 2012 SP1 it will be version 14.1.108.0

If none of these work, then you may need to run repairs and rendering using the ACTDIAG tool.

Cherie Buttsworth
ACT! Certified Consultant
Simply PC
cherie@simplypc.com.au
New Member
Posts: 7
Country: Netherlands

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

thank you,

this is the version I haveis; Sage ACT! Pro 2012 Version 14.1.108.0

What do you recommend I do, what is ACTDIAG tools and where do I find this?

thank you
Copper Elite Contributor
Posts: 260
Country: Australia

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Take a look at this KB Article it list a few solutions you can try.  One of which is the database rebuild & repair option.

Cherie Buttsworth
ACT! Certified Consultant
Simply PC
cherie@simplypc.com.au
New Member
Posts: 7
Country: Netherlands

Re: can I upgrade ACT 2007 to 2012 directly or will my data be damaged?

Thank you, where can I find /obtain this KB Article?

regards