Discussion:
SSMA upsizing error
(too old to reply)
Rik
15 years ago
Permalink
Hello,
I am trying to upsize a table from Access 2003 (.mdb) to SQL Server Express
2008 with SQL Server Migration Assistant 2008.

It works fine except for the migration of the data.
So the table i need is created correctly by SSMA in SQL Server but
i cannot get the data in it.

The SSMA log file says for every record:
Datamigrator: Error] [2392/8] [2009-12-26 15:00:51]: Inner Exception #1:
Incorrect syntax near '.'.
site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
source: .Net SqlClient Data Provider
error code: -2146232060
data: [HelpLink.ProdName] = [Microsoft SQL Server]
data: [HelpLink.ProdVer] = [10.00.1600]
data: [HelpLink.EvtSrc] = [MSSQLServer]
data: [HelpLink.EvtID] = [102]
data: [HelpLink.BaseHelpUrl] = [http://go.microsoft.com/fwlink]
data: [HelpLink.LinkId] = [20476]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQuery()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()


Any help is greatly appreceated!!

Rik de Jong
Sylvain Lafontaine
15 years ago
Permalink
I would say that this could happens if you have something strange in the
table's or the column's names like a dot or a slash; kind of: [fist.name] or
[date 2009/01/01].

Otherwise, you have to insert or import/export the data yourself instead of
using this tool.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
...
Rik
15 years ago
Permalink
I also have installed SQL Server Express 2005 on a second harddisk now on the
same PC.
It works OK now. I think it is an installation failure of the 2008 version.

Thank you.
...
Loading...