Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Problems migrating from Access to SQL using SSMA

Author  Topic 

iand109
Starting Member

14 Posts

Posted - 2009-10-05 : 05:30:44
Hi,
I am upsizing an Access database to SQL 2005. I've tried doing it using SSMA Access, and it mostly worked OK, except for the fact that none of the data was migrated. The log says (for each record):


[TreeConverter: Error] [4604/5] [2009-10-02 11:08:26]: Exception: Specified cast is not valid.
site: Void AssessRow(Microsoft.SSMA.Framework.Access.SqlServerTreeConverter.DataMigrationAssessmentReport.AccessRowState, Microsoft.SSMA.Framework.Generic.Converters.IConversionContext)
source: Microsoft.SSMA.Framework.Access.SqlServer
at Microsoft.SSMA.Framework.Access.SqlServerTreeConverter.DataMigrationAssessmentReport.DataRangeRowAssessor.AssessRow(AccessRowState row, IConversionContext context)

I've not been able to find any useful information that can help me. Can anyone out there shed any light on what my problem might be? Many thanks in advance.
   

- Advertisement -