如果Access文件名具有空格字符，则SSMA控制台脚本将失败 [英] SSMA Console Scripts fails if Access file name have white space characters

问题描述

我目前正在使用SSMA控制台脚本将MS-Access应用程序迁移到SQL Server。虽然我尝试使用Northwind.accdb，但一切正常。但是，当我将db重命名为"Northwind 1.accdb"后，我尝试使用相同的脚本。强制加载或映射架构命令的代码
失败



SSMA脚本命令，在下面的代码块中发生了故障。



< force-load object-name =" $ AccessDatabase $ .tables" 

object-type =" category" 

metabase =" source" />

变量值脚本代码段



  < variable-group name =" AccessConnection">

  &NBSP; < variable name =" $ AccessDbFolder $" value =" C：\Access DB Files" />

  &NBSP; < variable name =" $ AccessDatabase $" value =" Northwind 1" />

  &NBSP; < variable name =" $ AccessDatabaseFile $"值= QUOT; $ $ AccessDatabase .ACCDB" />

  < / variable-group>

下面是错误截图。

请帮助。

解决方案

嗨aruslelvan1，

 

>>我试了一下使用Northwind.accdb一切正常。但是，当我将db重命名为"Northwind 1.accdb"后，我尝试使用相同的脚本。强制加载或map-schema上的代码失败
命令  

 

请您检查脚本中的参数或尝试重新创建项目？以下是您可以参考的类似主题：

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5bff5114-cadc-4bd0-be56-f0bb5fc60ba5/ssma-setprojectpreference-error？ forum = sqlservermigration

 

希望这可以帮到你。

最好的问候，

Dedmon Dai

I am currently working on SSMA Console scripts to migrated MS-Access applications to SQL server. While I did a try with Northwind.accdb it all worked fine. However when I try the same script after renaming the db as "Northwind 1.accdb" the code failed on the force load or map-schema commands

SSMA Script command on which failure occurred at the below code block.

<force-load object-name="$AccessDatabase$.tables" 
object-type="category" 
metabase="source" />

Variable Value Script snippet

  <variable-group name="AccessConnection">
    <variable name="$AccessDbFolder$" value="C:\Access DB Files" />
    <variable name="$AccessDatabase$" value="Northwind 1" />
    <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.accdb" />
  </variable-group>

below is the error screenshot.

Kindly help.

解决方案

Hi aruslelvan1,

 

>>While I did a try with Northwind.accdb it all worked fine. However when I try the same script after renaming the db as "Northwind 1.accdb" the code failed on the force load or map-schema commands  

 

Would you please check the parameters in the script or try to recreate the project? Here is the similar thread you can refer to : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5bff5114-cadc-4bd0-be56-f0bb5fc60ba5/ssma-setprojectpreference-error?forum=sqlservermigration

 

Hope this could help you .

Best regards,

Dedmon Dai

这篇关于如果Access文件名具有空格字符，则SSMA控制台脚本将失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！