需要识别数据迁移助手中提到的从2008R2到2016的SQL Server升级中提到的对象 [英] Need to identify object mentioned in Data Migration Assistant for SQL Server Upgrade from 2008R2 to 2016

问题描述

你好，

Hi there,

我们计划将我们的数据库从SQL Server 2008R2升级到2016并在运行时数据迁移助手工具，我们发现了一个突破性变化：

We plan to upgrade our database from SQL Server 2008R2 to 2016 and while running the Data Migration Assistant tool, we found a breaking change that says:

在解析源数据库上的模式时，发现了一个或多个语法问题。源数据库上的语法问题表明某些对象包含不受支持的语法，因此没有在对象上运行所有评估规则。

While parsing the schema on the source database, one or more syntax issues were found. Syntax issues on the source database indicate that some objects contain unsupported syntax due to which all assessment rules were not run on the object.

它在受影响的对象中给出以下内容：

It gives following in Impacted Objects:

Object [CC_DBSpec]有语法错误。错误的语法附近] ..错误号46010.有关详细信息，请参阅：第2行，第23栏。

Object [CC_DBSpec] has syntax errors. Incorrect syntax near ].. Error number 46010. For more details, please see: Line 2, Column 23.

我们需要确定这个CC_DBSpec可以在哪里在我们的2008R2数据库中找到。

We need to identify where this CC_DBSpec can be found in our 2008R2 database.

我们尝试运行以下SQL但找不到对象：

We tried running following SQL but couldn't find the object:

SELECT NAME AS ObjectName，schema_name（o.schema_id）AS SchemaName，type，o.type_desc FROM sys.objects o WHERE o.is_ms_shipped = 0 AND o.NAME LIKE'％CC_DBSpec％'ORDER BY o.NAME ;

SELECT NAME AS ObjectName ,schema_name(o.schema_id) AS SchemaName ,type ,o.type_desc FROM sys.objects o WHERE o.is_ms_shipped = 0 AND o.NAME LIKE '%CC_DBSpec%' ORDER BY o.NAME;

你能帮我们识别这个物体吗？

Would you please help us identify this object?

谢谢。

推荐答案

嗨202020Ali，

Hi 202020Ali,

从你的T-SQL语句中，你检查了你拥有的所有SQL服务器数据库吗？

From your T-SQL statement, did you check all SQL server databases that you have?

SQL Server Management Studio提供了允许搜索的对象资源管理器详细信息功能对于在对象资源管理器窗格中选择的数据库中的任何对象。要首先在"对象资源管理器"面板中找到SQL Server数据库对象，请选择要在其上搜索对象的数据库
，并在"搜索"文本框中选择"对象资源管理器详细信息"面板键入搜索条件，然后按Enter键。这将返回与所选条件匹配的所有用户定义和系统对象。请尝试。

SQL Server Management Studio provides the Object Explorer Details feature that allows searching for any object in a database which is chosen in the Object Explorer pane.To find SQL Server database objects first in the Object Explorer panel, select the database over which wants to search the objects and in the Search text box from the Object Explorer Details panel type in the search criteria and press enter. This will return all user-defined and system objects that match with chosen criteria.Please have a try.

如果不起作用，请查看以下解决方案：在文件下面。请参阅 SQL Server数据库对象搜索。

希望这可以帮到你。



祝你好运，
Cathy Ji

If it is not work, please check the solutions from below document. Please refer to SQL Server database object search.
Hope this could help you.

Best regards,
Cathy Ji

这篇关于需要识别数据迁移助手中提到的从2008R2到2016的SQL Server升级中提到的对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！