如何避免通过SSMA添加SSMA_Timestamp列

Question

从Ms Access迁移到MSSQL Server时，SQL Server Migration Assistant将SSMA_Timestamp列添加到数据库中的所有表中。有没有办法避免这种情况？

​

​

Answer 1

如果您正在谈论SSMA版本7，那么尝试一下:在Tools>默认项目Settings>Tables>下，添加timestamp columns>，设置为Never。

​

​

Answer 2

<!-- Set project preference.
     Preference path/name/value can be found in preferences.prefs file stored in SSMA project directory.
     Preference path is the node name path starting from root to leaf node separating by "/". -->
<set-project-preference preference-path="prefs/ssma-for-access/a2ss/conversion"
                            preference-name="timestamp-columns-opt"
                            preference-value="never" />