Attempting to migrate the tables of an Access 2010 Northwind.accdb database created from the built-in Northwind template with the SQL Server Migration Assistant for Access v4.2 generates 670 log entries for 20 tables. The entries consist of 6 error, 245 warning, 233 information and 116 other messages.
Migration failed because of five instances of Access tables with unsupported Attachment field data types and one instance of an unsupported Lookup field data type. Many warnings are the result of the Access team’s inexplicable inclusion of spaces in field names.
Following is a complete copy of these log entries:
Starting conversion...
Analyzing metadata...
Converting table Northwind.[Customers] ...
Warnings: A2SS0030: Column 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'E-mail Address' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Job Title' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Business Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Home Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Mobile Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Fax Number' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Country/Region' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Web Page' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0021: The hyperlink column 'Web Page' was converted to a text column and, as a result, is no longer a link.
Errors: A2SS0070: Attachment datatype is not supported.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'City' was changed during conversion.
Information: A2SS0029: Index name 'Company' was changed during conversion.
Information: A2SS0029: Index name 'First Name' was changed during conversion.
Warnings: A2SS0030: Index 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Last Name' was changed during conversion.
Warnings: A2SS0030: Index 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Postal Code' was changed during conversion.
Warnings: A2SS0030: Index 'Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'State/Province' was changed during conversion.
Warnings: A2SS0030: Index 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Company' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Last Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'First Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'E-mail Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Job Title' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Business Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Home Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Mobile Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax Number' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'City' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'State/Province' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ZIP/Postal Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country/Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Web Page' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Employee Privileges] ...
Warnings: A2SS0030: Column 'Employee ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Privilege ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_EmployeePriviligesforEmployees' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_EmployeePriviligesforEmployees' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_EmployeePriviligesLookup' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_EmployeePriviligesLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'EmployeePriviligesforEmployees' was changed during conversion.
Warnings: A2SS0030: Index 'EmployeePriviligesforEmployees' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'EmployeePriviligesLookup' was changed during conversion.
Warnings: A2SS0030: Index 'EmployeePriviligesLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_EmployeePriviligesforEmployees' was changed during conversion.
Warnings: A2SS0030: Index 'New_EmployeePriviligesforEmployees' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_EmployeePriviligesLookup' was changed during conversion.
Warnings: A2SS0030: Index 'New_EmployeePriviligesLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Privilege ID' was changed during conversion.
Warnings: A2SS0030: Index 'Privilege ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Employee Privileges' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.EMPLOYEE PRIVILEGES.EMPLOYEE ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.EMPLOYEE PRIVILEGES.PRIVILEGE ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Employees] ...
Warnings: A2SS0030: Column 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'E-mail Address' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Job Title' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Business Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Home Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Mobile Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Fax Number' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Country/Region' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Web Page' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0021: The hyperlink column 'Web Page' was converted to a text column and, as a result, is no longer a link.
Errors: A2SS0070: Attachment datatype is not supported.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'City' was changed during conversion.
Information: A2SS0029: Index name 'Company' was changed during conversion.
Information: A2SS0029: Index name 'First Name' was changed during conversion.
Warnings: A2SS0030: Index 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Last Name' was changed during conversion.
Warnings: A2SS0030: Index 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Postal Code' was changed during conversion.
Warnings: A2SS0030: Index 'Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'State/Province' was changed during conversion.
Warnings: A2SS0030: Index 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Company' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Last Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'First Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'E-mail Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Job Title' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Business Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Home Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Mobile Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax Number' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'City' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'State/Province' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ZIP/Postal Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country/Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Web Page' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Inventory Transaction Types] ...
Warnings: A2SS0030: Column 'Type Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Inventory Transaction Types' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Type Name' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.INVENTORY TRANSACTION TYPES.ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Inventory Transactions] ...
Warnings: A2SS0030: Column 'Transaction ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Transaction Type' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Transaction Created Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Transaction Modified Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Product ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Customer Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_OrdersOnInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_OrdersOnInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_ProductOnInventoryTransaction' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_ProductOnInventoryTransaction' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_PuchaseOrdersonInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_PuchaseOrdersonInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_TransactionTypesOnInventoryTransactiosn' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_TransactionTypesOnInventoryTransactiosn' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Customer Order ID' was changed during conversion.
Warnings: A2SS0030: Index 'Customer Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_OrdersOnInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Index 'New_OrdersOnInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_ProductOnInventoryTransaction' was changed during conversion.
Warnings: A2SS0030: Index 'New_ProductOnInventoryTransaction' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_PuchaseOrdersonInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Index 'New_PuchaseOrdersonInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_TransactionTypesOnInventoryTransactiosn' was changed during conversion.
Warnings: A2SS0030: Index 'New_TransactionTypesOnInventoryTransactiosn' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrdersOnInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Index 'OrdersOnInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Product ID' was changed during conversion.
Warnings: A2SS0030: Index 'Product ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ProductOnInventoryTransaction' was changed during conversion.
Warnings: A2SS0030: Index 'ProductOnInventoryTransaction' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'PuchaseOrdersonInventoryTransactions' was changed during conversion.
Warnings: A2SS0030: Index 'PuchaseOrdersonInventoryTransactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Purchase Order ID' was changed during conversion.
Warnings: A2SS0030: Index 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'TransactionTypesOnInventoryTransactiosn' was changed during conversion.
Warnings: A2SS0030: Index 'TransactionTypesOnInventoryTransactiosn' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Inventory Transactions' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Comments' was converted to a check constraint.
Converting table Northwind.[Invoices] ...
Warnings: A2SS0030: Column 'Invoice ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Invoice Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Due Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Amount Due' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_OrderInvoice' was changed during conversion.
Information: A2SS0029: Index name 'New_OrderInvoice' was changed during conversion.
Information: A2SS0029: Index name 'Order ID' was changed during conversion.
Warnings: A2SS0030: Index 'Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrderInvoice' was changed during conversion.
Converting table Northwind.[Order Details] ...
Warnings: A2SS0030: Column 'Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Product ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Unit Price' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Date Allocated' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Inventory ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_OrderDetails' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_OrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_OrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_OrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_ProductsOnOrders' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_ProductsOnOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ID' was changed during conversion.
Warnings: A2SS0030: Index 'ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Inventory ID' was changed during conversion.
Warnings: A2SS0030: Index 'Inventory ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_OrderDetails' was changed during conversion.
Warnings: A2SS0030: Index 'New_OrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_OrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Index 'New_OrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_ProductsOnOrders' was changed during conversion.
Warnings: A2SS0030: Index 'New_ProductsOnOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrderDetails' was changed during conversion.
Warnings: A2SS0030: Index 'OrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrderID' was changed during conversion.
Warnings: A2SS0030: Index 'OrderID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Index 'OrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ProductID' was changed during conversion.
Warnings: A2SS0030: Index 'ProductID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ProductsOnOrders' was changed during conversion.
Warnings: A2SS0030: Index 'ProductsOnOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Purchase Order ID' was changed during conversion.
Warnings: A2SS0030: Index 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Status ID' was changed during conversion.
Warnings: A2SS0030: Index 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Order Details' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Order Details Status] ...
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Status Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Order Details Status' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Status Name' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.ORDER DETAILS STATUS.STATUS ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Orders] ...
Warnings: A2SS0030: Column 'Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Employee ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Customer ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Order Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Shipped Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Shipper ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship Address' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship City' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Ship Country/Region' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Shipping Fee' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Payment Type' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Paid Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Tax Rate' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Tax Status' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_CustomerOnOrders' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_EmployeesOnOrders' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_OrderStatus' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_ShipperOnOrder' was changed during conversion.
Information: A2SS0029: Foreign key name 'New_TaxStatusOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'CustomerID' was changed during conversion.
Information: A2SS0029: Index name 'CustomerOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'EmployeeID' was changed during conversion.
Information: A2SS0029: Index name 'EmployeesOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'ID' was changed during conversion.
Information: A2SS0029: Index name 'New_CustomerOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'New_EmployeesOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'New_OrderStatus' was changed during conversion.
Information: A2SS0029: Index name 'New_ShipperOnOrder' was changed during conversion.
Information: A2SS0029: Index name 'New_TaxStatusOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'OrderStatus' was changed during conversion.
Information: A2SS0029: Index name 'ShipperID' was changed during conversion.
Information: A2SS0029: Index name 'ShipperOnOrder' was changed during conversion.
Information: A2SS0029: Index name 'Status ID' was changed during conversion.
Warnings: A2SS0030: Index 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'TaxStatusOnOrders' was changed during conversion.
Information: A2SS0029: Index name 'ZIP/Postal Code' was changed during conversion.
Warnings: A2SS0030: Index 'ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship City' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship State/Province' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship ZIP/Postal Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Ship Country/Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Payment Type' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Orders Status] ...
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Status Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Orders Status' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Status Name' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.ORDERS STATUS.STATUS ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Orders Tax Status] ...
Warnings: A2SS0030: Column 'Tax Status Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Orders Tax Status' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Tax Status Name' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.ORDERS TAX STATUS.ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Privileges] ...
Warnings: A2SS0030: Column 'Privilege ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Privilege Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Privilege Name' was converted to a check constraint.
Converting table Northwind.[Products] ...
Warnings: A2SS0030: Column 'Supplier IDs' has a name that might cause problems for the Access application to function correctly against SQL Server.
Errors: A2SS0070: ComplexLong datatype is not supported.
Warnings: A2SS0030: Column 'Product Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Product Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Standard Cost' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'List Price' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Reorder Level' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Target Level' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Quantity Per Unit' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Minimum Reorder Quantity' has a name that might cause problems for the Access application to function correctly against SQL Server.
Errors: A2SS0070: Attachment datatype is not supported.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'Product Code' was changed during conversion.
Warnings: A2SS0030: Index 'Product Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Product Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Product Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Description' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Quantity Per Unit' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Category' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Purchase Order Details] ...
Warnings: A2SS0030: Column 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Product ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Unit Cost' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Date Received' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Posted To Inventory' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Inventory ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_InventoryTransactionsOnPurchaseOrders' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_InventoryTransactionsOnPurchaseOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_ProductOnPurchaseOrderDetails' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_ProductOnPurchaseOrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_PurchaseOrderDeatilsOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_PurchaseOrderDeatilsOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ID' was changed during conversion.
Warnings: A2SS0030: Index 'ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Inventory ID' was changed during conversion.
Warnings: A2SS0030: Index 'Inventory ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'InventoryTransactionsOnPurchaseOrders' was changed during conversion.
Warnings: A2SS0030: Index 'InventoryTransactionsOnPurchaseOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_InventoryTransactionsOnPurchaseOrders' was changed during conversion.
Warnings: A2SS0030: Index 'New_InventoryTransactionsOnPurchaseOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_ProductOnPurchaseOrderDetails' was changed during conversion.
Warnings: A2SS0030: Index 'New_ProductOnPurchaseOrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_PurchaseOrderDeatilsOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'New_PurchaseOrderDeatilsOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'OrderID' was changed during conversion.
Warnings: A2SS0030: Index 'OrderID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ProductID' was changed during conversion.
Warnings: A2SS0030: Index 'ProductID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ProductOnPurchaseOrderDetails' was changed during conversion.
Warnings: A2SS0030: Index 'ProductOnPurchaseOrderDetails' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'PurchaseOrderDeatilsOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'PurchaseOrderDeatilsOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Purchase Order Details' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Purchase Order Status] ...
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Purchase Order Status' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Status' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.ACCDB.PURCHASE ORDER STATUS.STATUS ID' of the primary key is nullable, which SQL Server does not allow. The nullable flag was removed from the target column to avoid problems during loading database objects into SQL Server. If there are rows that contain NULL values, you might encounter problems during data migration.
Converting table Northwind.[Purchase Orders] ...
Warnings: A2SS0030: Column 'Purchase Order ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Supplier ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Created By' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Submitted Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Creation Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Expected Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Shipping Fee' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Payment Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Payment Amount' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Payment Method' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Approved By' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Approved Date' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Submitted By' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_EmployeesOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_EmployeesOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_PurchaseOrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_PurchaseOrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'New_SuppliersOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Foreign key 'New_SuppliersOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'EmployeesOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'EmployeesOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'ID' was changed during conversion.
Warnings: A2SS0030: Index 'ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_EmployeesOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'New_EmployeesOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_PurchaseOrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Index 'New_PurchaseOrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'New_SuppliersOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'New_SuppliersOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'PurchaseOrderStatusLookup' was changed during conversion.
Warnings: A2SS0030: Index 'PurchaseOrderStatusLookup' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Status ID' was changed during conversion.
Warnings: A2SS0030: Index 'Status ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'SupplierID' was changed during conversion.
Warnings: A2SS0030: Index 'SupplierID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'SuppliersOnPurchaseOrder' was changed during conversion.
Warnings: A2SS0030: Index 'SuppliersOnPurchaseOrder' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Purchase Orders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Payment Method' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Sales Reports] ...
Warnings: A2SS0030: Column 'Group By' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Filter Row Source' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Default' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Warnings: A2SS0030: Primary key 'PrimaryKey' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Table 'Sales Reports' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Group By' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Display' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Title' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Filter Row Source' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Shippers] ...
Warnings: A2SS0030: Column 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'E-mail Address' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Job Title' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Business Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Home Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Mobile Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Fax Number' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Country/Region' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Web Page' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0021: The hyperlink column 'Web Page' was converted to a text column and, as a result, is no longer a link.
Errors: A2SS0070: Attachment datatype is not supported.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'City' was changed during conversion.
Information: A2SS0029: Index name 'Company' was changed during conversion.
Information: A2SS0029: Index name 'First Name' was changed during conversion.
Warnings: A2SS0030: Index 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Last Name' was changed during conversion.
Warnings: A2SS0030: Index 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Postal Code' was changed during conversion.
Warnings: A2SS0030: Index 'Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'State/Province' was changed during conversion.
Warnings: A2SS0030: Index 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Company' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Last Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'First Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'E-mail Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Job Title' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Business Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Home Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Mobile Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax Number' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'City' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'State/Province' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ZIP/Postal Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country/Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Web Page' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Strings] ...
Warnings: A2SS0030: Column 'String ID' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'String Data' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'String Data' was converted to a check constraint.
Converting table Northwind.[Suppliers] ...
Warnings: A2SS0030: Column 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'E-mail Address' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Job Title' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Business Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Home Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Mobile Phone' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Fax Number' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'ZIP/Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Country/Region' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0030: Column 'Web Page' has a name that might cause problems for the Access application to function correctly against SQL Server.
Warnings: A2SS0021: The hyperlink column 'Web Page' was converted to a text column and, as a result, is no longer a link.
Errors: A2SS0070: Attachment datatype is not supported.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'City' was changed during conversion.
Information: A2SS0029: Index name 'Company' was changed during conversion.
Information: A2SS0029: Index name 'First Name' was changed during conversion.
Warnings: A2SS0030: Index 'First Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Last Name' was changed during conversion.
Warnings: A2SS0030: Index 'Last Name' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Postal Code' was changed during conversion.
Warnings: A2SS0030: Index 'Postal Code' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'State/Province' was changed during conversion.
Warnings: A2SS0030: Index 'State/Province' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Company' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Last Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'First Name' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'E-mail Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Job Title' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Business Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Home Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Mobile Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax Number' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Address' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'City' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'State/Province' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ZIP/Postal Code' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country/Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Web Page' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Notes' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Conversion finished with 6 errors, 245 warnings, and 233 informational messages.
Loading objects into database...
Analyzing metadata...
Preparing category Tables of schema Northwind.dbo...
Preparing table Northwind.dbo.[Customers]...
Preparing category Triggers of table Northwind.dbo.[Customers]...
Preparing category Indexes of table Northwind.dbo.[Customers]...
Preparing index Northwind.dbo.[Customers].[Customers$City]...
Preparing index Northwind.dbo.[Customers].[Customers$Company]...
Preparing index Northwind.dbo.[Customers].[Customers$First Name]...
Preparing index Northwind.dbo.[Customers].[Customers$Last Name]...
Preparing index Northwind.dbo.[Customers].[Customers$Postal Code]...
Preparing index Northwind.dbo.[Customers].[Customers$State/Province]...
Preparing table Northwind.dbo.[Employee Privileges]...
Preparing category Triggers of table Northwind.dbo.[Employee Privileges]...
Preparing category Indexes of table Northwind.dbo.[Employee Privileges]...
Preparing index Northwind.dbo.[Employee Privileges].[Employee Privileges$EmployeePriviligesforEmployees]...
Preparing index Northwind.dbo.[Employee Privileges].[Employee Privileges$EmployeePriviligesLookup]...
Preparing index Northwind.dbo.[Employee Privileges].[Employee Privileges$New_EmployeePriviligesforEmployees]...
Preparing index Northwind.dbo.[Employee Privileges].[Employee Privileges$New_EmployeePriviligesLookup]...
Preparing index Northwind.dbo.[Employee Privileges].[Employee Privileges$Privilege ID]...
Preparing table Northwind.dbo.[Employees]...
Preparing category Triggers of table Northwind.dbo.[Employees]...
Preparing category Indexes of table Northwind.dbo.[Employees]...
Preparing index Northwind.dbo.[Employees].[Employees$City]...
Preparing index Northwind.dbo.[Employees].[Employees$Company]...
Preparing index Northwind.dbo.[Employees].[Employees$First Name]...
Preparing index Northwind.dbo.[Employees].[Employees$Last Name]...
Preparing index Northwind.dbo.[Employees].[Employees$Postal Code]...
Preparing index Northwind.dbo.[Employees].[Employees$State/Province]...
Preparing table Northwind.dbo.[Inventory Transaction Types]...
Preparing category Triggers of table Northwind.dbo.[Inventory Transaction Types]...
Preparing category Indexes of table Northwind.dbo.[Inventory Transaction Types]...
Preparing table Northwind.dbo.[Inventory Transactions]...
Preparing category Triggers of table Northwind.dbo.[Inventory Transactions]...
Preparing category Indexes of table Northwind.dbo.[Inventory Transactions]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$Customer Order ID]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$New_OrdersOnInventoryTransactions]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$New_ProductOnInventoryTransaction]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$New_PuchaseOrdersonInventoryTransactions]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$New_TransactionTypesOnInventoryTransactiosn]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$OrdersOnInventoryTransactions]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$Product ID]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$ProductOnInventoryTransaction]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$PuchaseOrdersonInventoryTransactions]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$Purchase Order ID]...
Preparing index Northwind.dbo.[Inventory Transactions].[Inventory Transactions$TransactionTypesOnInventoryTransactiosn]...
Preparing table Northwind.dbo.[Invoices]...
Preparing category Triggers of table Northwind.dbo.[Invoices]...
Preparing category Indexes of table Northwind.dbo.[Invoices]...
Preparing index Northwind.dbo.[Invoices].[Invoices$New_OrderInvoice]...
Preparing index Northwind.dbo.[Invoices].[Invoices$Order ID]...
Preparing index Northwind.dbo.[Invoices].[Invoices$OrderInvoice]...
Preparing table Northwind.dbo.[Order Details]...
Preparing category Triggers of table Northwind.dbo.[Order Details]...
Preparing category Indexes of table Northwind.dbo.[Order Details]...
Preparing index Northwind.dbo.[Order Details].[Order Details$ID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$Inventory ID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$New_OrderDetails]...
Preparing index Northwind.dbo.[Order Details].[Order Details$New_OrderStatusLookup]...
Preparing index Northwind.dbo.[Order Details].[Order Details$New_ProductsOnOrders]...
Preparing index Northwind.dbo.[Order Details].[Order Details$OrderDetails]...
Preparing index Northwind.dbo.[Order Details].[Order Details$OrderID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$OrderStatusLookup]...
Preparing index Northwind.dbo.[Order Details].[Order Details$ProductID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$ProductsOnOrders]...
Preparing index Northwind.dbo.[Order Details].[Order Details$Purchase Order ID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$Status ID]...
Preparing table Northwind.dbo.[Order Details Status]...
Preparing category Triggers of table Northwind.dbo.[Order Details Status]...
Preparing category Indexes of table Northwind.dbo.[Order Details Status]...
Preparing table Northwind.dbo.[Orders]...
Preparing category Triggers of table Northwind.dbo.[Orders]...
Preparing category Indexes of table Northwind.dbo.[Orders]...
Preparing index Northwind.dbo.[Orders].[Orders$CustomerID]...
Preparing index Northwind.dbo.[Orders].[Orders$CustomerOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$EmployeeID]...
Preparing index Northwind.dbo.[Orders].[Orders$EmployeesOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$ID]...
Preparing index Northwind.dbo.[Orders].[Orders$New_CustomerOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$New_EmployeesOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$New_OrderStatus]...
Preparing index Northwind.dbo.[Orders].[Orders$New_ShipperOnOrder]...
Preparing index Northwind.dbo.[Orders].[Orders$New_TaxStatusOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$OrderStatus]...
Preparing index Northwind.dbo.[Orders].[Orders$ShipperID]...
Preparing index Northwind.dbo.[Orders].[Orders$ShipperOnOrder]...
Preparing index Northwind.dbo.[Orders].[Orders$Status ID]...
Preparing index Northwind.dbo.[Orders].[Orders$TaxStatusOnOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$ZIP/Postal Code]...
Preparing table Northwind.dbo.[Orders Status]...
Preparing category Triggers of table Northwind.dbo.[Orders Status]...
Preparing category Indexes of table Northwind.dbo.[Orders Status]...
Preparing table Northwind.dbo.[Orders Tax Status]...
Preparing category Triggers of table Northwind.dbo.[Orders Tax Status]...
Preparing category Indexes of table Northwind.dbo.[Orders Tax Status]...
Preparing table Northwind.dbo.[Privileges]...
Preparing category Triggers of table Northwind.dbo.[Privileges]...
Preparing category Indexes of table Northwind.dbo.[Privileges]...
Preparing table Northwind.dbo.[Products]...
Preparing category Triggers of table Northwind.dbo.[Products]...
Preparing category Indexes of table Northwind.dbo.[Products]...
Preparing index Northwind.dbo.[Products].[Products$Product Code]...
Preparing table Northwind.dbo.[Purchase Order Details]...
Preparing category Triggers of table Northwind.dbo.[Purchase Order Details]...
Preparing category Indexes of table Northwind.dbo.[Purchase Order Details]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$ID]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$Inventory ID]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$InventoryTransactionsOnPurchaseOrders]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$New_InventoryTransactionsOnPurchaseOrders]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$New_ProductOnPurchaseOrderDetails]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$New_PurchaseOrderDeatilsOnPurchaseOrder]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$OrderID]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$ProductID]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$ProductOnPurchaseOrderDetails]...
Preparing index Northwind.dbo.[Purchase Order Details].[Purchase Order Details$PurchaseOrderDeatilsOnPurchaseOrder]...
Preparing table Northwind.dbo.[Purchase Order Status]...
Preparing category Triggers of table Northwind.dbo.[Purchase Order Status]...
Preparing category Indexes of table Northwind.dbo.[Purchase Order Status]...
Preparing table Northwind.dbo.[Purchase Orders]...
Preparing category Triggers of table Northwind.dbo.[Purchase Orders]...
Preparing category Indexes of table Northwind.dbo.[Purchase Orders]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$EmployeesOnPurchaseOrder]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$ID]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$New_EmployeesOnPurchaseOrder]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$New_PurchaseOrderStatusLookup]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$New_SuppliersOnPurchaseOrder]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$PurchaseOrderStatusLookup]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$Status ID]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$SupplierID]...
Preparing index Northwind.dbo.[Purchase Orders].[Purchase Orders$SuppliersOnPurchaseOrder]...
Preparing table Northwind.dbo.[Sales Reports]...
Preparing category Triggers of table Northwind.dbo.[Sales Reports]...
Preparing category Indexes of table Northwind.dbo.[Sales Reports]...
Preparing table Northwind.dbo.[Shippers]...
Preparing category Triggers of table Northwind.dbo.[Shippers]...
Preparing category Indexes of table Northwind.dbo.[Shippers]...
Preparing index Northwind.dbo.[Shippers].[Shippers$City]...
Preparing index Northwind.dbo.[Shippers].[Shippers$Company]...
Preparing index Northwind.dbo.[Shippers].[Shippers$First Name]...
Preparing index Northwind.dbo.[Shippers].[Shippers$Last Name]...
Preparing index Northwind.dbo.[Shippers].[Shippers$Postal Code]...
Preparing index Northwind.dbo.[Shippers].[Shippers$State/Province]...
Preparing table Northwind.dbo.[Strings]...
Preparing category Triggers of table Northwind.dbo.[Strings]...
Preparing category Indexes of table Northwind.dbo.[Strings]...
Preparing table Northwind.dbo.[Suppliers]...
Preparing category Triggers of table Northwind.dbo.[Suppliers]...
Preparing category Indexes of table Northwind.dbo.[Suppliers]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$City]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$Company]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$First Name]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$Last Name]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$Postal Code]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$State/Province]...
Synchronization operation was canceled by user.
Load operation is complete.
Migrating data...
Analyzing metadata...
Data migration operation has finished.
0 table(s) successfully migrated.
0 table(s) partially migrated.
0 table(s) failed to migrate.
Operation canceled.
No comments:
Post a Comment