i have to upgrade Small Buisness accounting 2006 Professional to Microsoft Office accounting 2009 professional by retaining the 2006 company file data.

Can anybody help me to upgrade it?
I have already tried backup and restor the company file from 2006 version to 2009. it restored the file successfully. when i tried to open the the restored file in Microsoft Office accounting 2009 ,it asked me to upgrade the file and i followed the wizard steps. while upgrading the data it gives error and upgrade process failed with error. following is the error i have found in the log file.
<Comment>Alter AccountRegisterLineID to not nullable</Comment>
<SqlCommand><SqlString> ALTER TABLE ReconciledBankCreditCardTransactionTable ALTER COLUMN AccountRegisterLineID INT NOT NULL
</SqlString></SqlCommand><ResultFailure><Exception>System.Data.S qlClient.SqlException: Cannot insert the value NULL into column 'AccountRegisterLineID', table 'MyCompnayData.dbo.ReconciledBankCreditCardTransac tionTable'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.BusinessSolutions.SmallBusinessAccountin g.DBUpgradeShell.ExecuteRunSql(String comment, String SqlString, Boolean raiseEvent, Boolean skipLog)</Exception></ResultFailure></Command>
<Command TimeTaken="00:00:00.0048830" StartTime="5/26/2010 11:52:55 AM" Sequence="18285>
<Comment>Marking database as invalid</Comment>
<SqlCommand><SqlString>UPDATE VersionInfoTable SET DatabaseState = 2</SqlString></SqlCommand><ResultSuccess>number of rows = "1"</ResultSuccess></Command>
<Comment Time="5/26/2010 11:52:55 AM">Db upgrade failed.</Comment>
<Comment Time="5/26/2010 11:52:55 AM">System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'AccountRegisterLineID', table 'MyCompnayData.dbo.ReconciledBankCreditCardTransac tionTable'; column does not allow nulls. UPDATE fails.
MyCompnayData is the database name generated by the upgrde process
I have also read articles on upgrading from 2006 to 2009 , everybody recommend for microsoft free upgrde at
http://www.ideawins.com/Upgrade.aspx. but this lonk is not working.
plese help me sort out the above problem
Thanks in advance