I'm using DTS to import data from an Access database to SQL Server 2005. It seems that DTS imports Access queries as tables instead of views, which won't work for me. Is there any way around that?
我正在使用DTS从访问数据库导入数据到SQL Server 2005。看起来DTS将访问查询作为表而不是视图来导入，这对我来说是行不通的。有办法解决这个问题吗?
1 个解决方案
#1
3
You can choose to not include the saved queries. (at least you can when using the SSMA - I suggest you use this in place of DTS anyway…it tends to do a better job).
您可以选择不包含已保存的查询。(至少你可以在使用SSMA的时候——我建议你用这个代替DTS，它会做得更好)。
you can find it here: http://www.microsoft.com/sqlserver/2005/en/us/migration.aspx
您可以在这里找到它:http://www.microsoft.com/sqlserver/2005/en/us/migr.aspx
It is not clear if you going to continue to use ms-access as the front end here or not?. If you plan to continue using access then you really don’t need to convert those saved queries (views) up to sql server anyway. Most of the saved queries in access will work as before (now with linked tables to sql server).
不清楚你是否会继续使用ms-access作为前端?如果您打算继续使用access，那么无论如何您都不需要将保存的查询(视图)转换为sql server。在access中保存的大多数查询将与以前一样工作(现在使用到sql server的链接表)。
You only need change/fix those saved quires that run slow. In other words most queries can continue to be used and run as is. It is only the slow ones and especially the ones with aggregate functions (sums, totals etc that process many records, but produce few rows). This types of queries really benefit from being moved up to sql server as a view (you then link to that view from ms-access).
您只需要修改/修复那些运行缓慢的保存的请求。换句话说，大多数查询可以继续使用并按原样运行。只有慢的记录，特别是具有聚合函数(和、总数等)的记录处理得多，但生成的行却少。这种类型的查询真正受益于作为视图移动到sql server(然后从ms-access链接到该视图)。
If your not keeping any part of ms-access, then I am afraid there no automated tool for those queries. In these cases I just do a cut + paste from ms-access right into the management studio view builder. Most queries require very little modifications.
如果您没有保存任何ms-access的部分，那么我担心这些查询没有自动工具。在这些情况下，我只需从ms-access中剪切+粘贴到management studio视图构建器中。大多数查询只需要很少的修改。
#1
3
You can choose to not include the saved queries. (at least you can when using the SSMA - I suggest you use this in place of DTS anyway…it tends to do a better job).
您可以选择不包含已保存的查询。(至少你可以在使用SSMA的时候——我建议你用这个代替DTS，它会做得更好)。
you can find it here: http://www.microsoft.com/sqlserver/2005/en/us/migration.aspx
您可以在这里找到它:http://www.microsoft.com/sqlserver/2005/en/us/migr.aspx
It is not clear if you going to continue to use ms-access as the front end here or not?. If you plan to continue using access then you really don’t need to convert those saved queries (views) up to sql server anyway. Most of the saved queries in access will work as before (now with linked tables to sql server).
不清楚你是否会继续使用ms-access作为前端?如果您打算继续使用access，那么无论如何您都不需要将保存的查询(视图)转换为sql server。在access中保存的大多数查询将与以前一样工作(现在使用到sql server的链接表)。
You only need change/fix those saved quires that run slow. In other words most queries can continue to be used and run as is. It is only the slow ones and especially the ones with aggregate functions (sums, totals etc that process many records, but produce few rows). This types of queries really benefit from being moved up to sql server as a view (you then link to that view from ms-access).
您只需要修改/修复那些运行缓慢的保存的请求。换句话说，大多数查询可以继续使用并按原样运行。只有慢的记录，特别是具有聚合函数(和、总数等)的记录处理得多，但生成的行却少。这种类型的查询真正受益于作为视图移动到sql server(然后从ms-access链接到该视图)。
If your not keeping any part of ms-access, then I am afraid there no automated tool for those queries. In these cases I just do a cut + paste from ms-access right into the management studio view builder. Most queries require very little modifications.
如果您没有保存任何ms-access的部分，那么我担心这些查询没有自动工具。在这些情况下，我只需从ms-access中剪切+粘贴到management studio视图构建器中。大多数查询只需要很少的修改。