Promote
Manually Ignore Objects
Columns can be ignored at a global level so that every package ignores the configured objects during the comparison and transport process. Objects can also be ignored for individual packages.
There are two ways to manually ignore objects:
-
Add the object to the package. This method is helpful when users are configuring the package and already know which specific objects need to be ignored.
-
Select the object during the review. This method is helpful when it is noticed during the package review that an object needs to be ignored.
To add the object to be ignored to the package:
-
Click Packages in the Navigation pane.
-
Click the Packages icon for a package group.
-
Click Vertical View for a package.
-
Click the Manual Objects tab.
-
Click the Manual Ignore Objects icon.
-
Click Add.
View the page description for the Package - Manual Ignore Object page
-
Select a database that stores that column to be ignored from the DATABASE list box.
-
Select the specific object to be ignored from the OBJECT NAME list box.
-
Click Save.
To select the object to be ignored during the review:
-
Click Packages in the Navigation pane.
-
Click the Packages icon for a package group.
-
Click the SQL Objects icon for a package.
-
Click one of the hyperlinks:
-
NOT IN DEST—Displays tables that exist on the host server, but not on the destination server.
-
DIFFERENT—Displays tables that exist on both the host and the destination servers, but have different values for columns that are being compared.
-
SAME—Displays tables that exist on the host and the destination servers, and there are no differences between the columns that are being compared.
-
QUEUE— Displays all tables that have been selected to be transported.
-
ALL— Displays all records on the selected table.
-
Click the Always Ignore icon for an object name.