If you are creating a package to upgrade a database, you can select tables to package their data only if they have:

• similar names
  You can set SQL Packager so that it ignores the case of object names, and spaces or underscores in object names by using the data packaging options.
• the same owner (case-sensitive)
• similar schema
• a matching primary key, unique index, or unique constraint that has the same name in both databases

If the tables are very different, for example if primary keys or column data types are different, SQL Packager cannot upgrade the data. Red Gate offers SQL Compare, which will synchronize the schema of two databases. You can then use SQL Packager to package an upgrade to the data.

Alternatively, you could use SQL Packager to upgrade the schema, then generate a second package to upgrade the data. For details, see Upgrading the database structure and data.

In addition, if the structure of the databases that you have selected has changed while you are working on a project, those changes are not automatically shown in the Choose the tables whose data will be packaged page of the Packager Wizard. To refresh the page, click ; you can then select the tables. For more information, see Specifying the package contents.