Successfully migrating the tables of an Access 2003 Northwind.mdb sample database with the SQL Server Migration Assistant for Access v4.2 generates 325 log entries for 9 tables. You can download Northwind.mdb from my Windows Live Skydrive instance here.
You also can download NwindAzure.mdb, which is a Access front-end for tables linked by a publically accessible Northwind SQL Azure database, here. Running NwindAzure.mdb will open a connection to the Northwind database running in Microsoft’s South Centeral US (San Antonio, TX) data center.
Following is a complete copy of these log entries:
Starting conversion...
Analyzing metadata...
Converting table Northwind.[Categories] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'CategoryName' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CategoryName' 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: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Customers] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'City' was changed during conversion.
Information: A2SS0029: Index name 'CompanyName' was changed during conversion.
Information: A2SS0029: Index name 'PostalCode' was changed during conversion.
Information: A2SS0029: Index name 'Region' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CustomerID' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CompanyName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ContactName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ContactTitle' 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 'Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'PostalCode' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax' was converted to a check constraint.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.MDB.CUSTOMERS.CUSTOMERID' 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] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'LastName' was changed during conversion.
Information: A2SS0029: Index name 'PostalCode' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'LastName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'FirstName' 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 'TitleOfCourtesy' 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 'Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'PostalCode' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'HomePhone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Extension' 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.[HRActions] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'ActionTypeEffDate' was changed during conversion.
Information: A2SS0029: Index name 'EffectiveDate' was changed during conversion.
Information: A2SS0029: Index name 'HRActionsEmployeeID' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ActionType' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Order Details] ...
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 'Order DetailsOrders' was changed during conversion.
Warnings: A2SS0030: Foreign key 'Order DetailsOrders' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Foreign key name 'ProductsOrder Details' was changed during conversion.
Warnings: A2SS0030: Foreign key 'ProductsOrder Details' has a name that might cause problems for the Access application to function correctly against SQL Server.
Information: A2SS0029: Index name 'Order DetailsOrders' was changed during conversion.
Warnings: A2SS0030: Index 'Order DetailsOrders' 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 'ProductsOrder Details' was changed during conversion.
Warnings: A2SS0030: Index 'ProductsOrder Details' 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.
Warnings: A2SS0016: Column 'C:\USERS\ADMINISTRATOR\DOCUMENTS\NORTHWIND.MDB.ORDER DETAILS.ORDERID' 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.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Orders] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Foreign key name 'CustomersOrders' was changed during conversion.
Information: A2SS0029: Foreign key name 'EmployeesOrders' was changed during conversion.
Information: A2SS0029: Foreign key name 'OrdersShippers' was changed during conversion.
Information: A2SS0029: Foreign key name 'ShippersOrders' was changed during conversion.
Information: A2SS0029: Index name 'CustomerID' was changed during conversion.
Information: A2SS0029: Index name 'CustomersOrders' was changed during conversion.
Information: A2SS0029: Index name 'EmployeeID' was changed during conversion.
Information: A2SS0029: Index name 'EmployeesOrders' was changed during conversion.
Information: A2SS0029: Index name 'OrderDate' was changed during conversion.
Information: A2SS0029: Index name 'OrdersShippers' was changed during conversion.
Information: A2SS0029: Index name 'ShippedDate' was changed during conversion.
Information: A2SS0029: Index name 'ShippersOrders' was changed during conversion.
Information: A2SS0029: Index name 'ShipPostalCode' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CustomerID' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipAddress' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipCity' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipRegion' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipPostalCode' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ShipCountry' was converted to a check constraint.
Converting table Northwind.[Products] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Foreign key name 'CategoriesProducts' was changed during conversion.
Information: A2SS0029: Foreign key name 'ProductsCategories' was changed during conversion.
Information: A2SS0029: Foreign key name 'SuppliersProducts' was changed during conversion.
Information: A2SS0029: Index name 'CategoriesProducts' was changed during conversion.
Information: A2SS0029: Index name 'CategoryID' was changed during conversion.
Information: A2SS0029: Index name 'ProductName' was changed during conversion.
Information: A2SS0029: Index name 'ProductsCategories' was changed during conversion.
Information: A2SS0029: Index name 'SupplierID' was changed during conversion.
Information: A2SS0029: Index name 'SuppliersProducts' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ProductName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'QuantityPerUnit' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Converting table Northwind.[Shippers] ...
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CompanyName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Phone' was converted to a check constraint.
Converting table Northwind.[Suppliers] ...
Warnings: A2SS0021: The hyperlink column 'HomePage' was converted to a text column and, as a result, is no longer a link.
Information: A2SS0029: Primary key name 'PrimaryKey' was changed during conversion.
Information: A2SS0029: Index name 'CompanyName' was changed during conversion.
Information: A2SS0029: Index name 'PostalCode' was changed during conversion.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'CompanyName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ContactName' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ContactTitle' 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 'Region' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'PostalCode' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Country' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Phone' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'Fax' was converted to a check constraint.
Information: A2SS0005: The Zero-length-not-allowed flag on the column 'HomePage' was converted to a check constraint.
Information: A2SS0020: New timestamp column 'SSMA_TimeStamp' created.
Conversion finished with 0 errors, 11 warnings, and 103 informational messages.
Loading objects into database...
Analyzing metadata...
Preparing category Tables of schema Northwind.dbo...
Preparing table Northwind.dbo.[Categories]...
Preparing category Triggers of table Northwind.dbo.[Categories]...
Preparing category Indexes of table Northwind.dbo.[Categories]...
Preparing index Northwind.dbo.[Categories].[Categories$CategoryName]...
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$CompanyName]...
Preparing index Northwind.dbo.[Customers].[Customers$PostalCode]...
Preparing index Northwind.dbo.[Customers].[Customers$Region]...
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$LastName]...
Preparing index Northwind.dbo.[Employees].[Employees$PostalCode]...
Preparing table Northwind.dbo.[HRActions]...
Preparing category Triggers of table Northwind.dbo.[HRActions]...
Preparing category Indexes of table Northwind.dbo.[HRActions]...
Preparing index Northwind.dbo.[HRActions].[HRActions$ActionTypeEffDate]...
Preparing index Northwind.dbo.[HRActions].[HRActions$EffectiveDate]...
Preparing index Northwind.dbo.[HRActions].[HRActions$HRActionsEmployeeID]...
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$Order DetailsOrders]...
Preparing index Northwind.dbo.[Order Details].[Order Details$OrderID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$ProductID]...
Preparing index Northwind.dbo.[Order Details].[Order Details$ProductsOrder Details]...
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$CustomersOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$EmployeeID]...
Preparing index Northwind.dbo.[Orders].[Orders$EmployeesOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$OrderDate]...
Preparing index Northwind.dbo.[Orders].[Orders$OrdersShippers]...
Preparing index Northwind.dbo.[Orders].[Orders$ShippedDate]...
Preparing index Northwind.dbo.[Orders].[Orders$ShippersOrders]...
Preparing index Northwind.dbo.[Orders].[Orders$ShipPostalCode]...
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$CategoriesProducts]...
Preparing index Northwind.dbo.[Products].[Products$CategoryID]...
Preparing index Northwind.dbo.[Products].[Products$ProductName]...
Preparing index Northwind.dbo.[Products].[Products$ProductsCategories]...
Preparing index Northwind.dbo.[Products].[Products$SupplierID]...
Preparing index Northwind.dbo.[Products].[Products$SuppliersProducts]...
Preparing table Northwind.dbo.[Shippers]...
Preparing category Triggers of table Northwind.dbo.[Shippers]...
Preparing category Indexes of table Northwind.dbo.[Shippers]...
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$CompanyName]...
Preparing index Northwind.dbo.[Suppliers].[Suppliers$PostalCode]...
Starting Phase #0
Synchronizing Northwind.dbo ...
Loading to database new table Northwind.dbo.[Categories] ...
Loading to database new table Northwind.dbo.[Customers] ...
Loading to database new table Northwind.dbo.[Employees] ...
Loading to database new table Northwind.dbo.[HRActions] ...
Loading to database new table Northwind.dbo.[Order Details] ...
Loading to database new table Northwind.dbo.[Orders] ...
Loading to database new table Northwind.dbo.[Products] ...
Loading to database new table Northwind.dbo.[Shippers] ...
Loading to database new table Northwind.dbo.[Suppliers] ...
Loading to database new table Northwind.dbo.[Categories] primary keys ...
Loading to database new table Northwind.dbo.[Customers] primary keys ...
Loading to database new table Northwind.dbo.[Employees] primary keys ...
Loading to database new table Northwind.dbo.[HRActions] primary keys ...
Loading to database new table Northwind.dbo.[Order Details] primary keys ...
Loading to database new table Northwind.dbo.[Orders] primary keys ...
Loading to database new table Northwind.dbo.[Products] primary keys ...
Loading to database new table Northwind.dbo.[Shippers] primary keys ...
Loading to database new table Northwind.dbo.[Suppliers] primary keys ...
Loading to database new index Northwind.dbo.[Categories].[Categories$CategoryName] ...
Loading to database new index Northwind.dbo.[Customers].[Customers$City] ...
Loading to database new index Northwind.dbo.[Customers].[Customers$CompanyName] ...
Loading to database new index Northwind.dbo.[Customers].[Customers$PostalCode] ...
Loading to database new index Northwind.dbo.[Customers].[Customers$Region] ...
Loading to database new index Northwind.dbo.[Employees].[Employees$LastName] ...
Loading to database new index Northwind.dbo.[Employees].[Employees$PostalCode] ...
Loading to database new index Northwind.dbo.[HRActions].[HRActions$ActionTypeEffDate] ...
Loading to database new index Northwind.dbo.[HRActions].[HRActions$EffectiveDate] ...
Loading to database new index Northwind.dbo.[HRActions].[HRActions$HRActionsEmployeeID] ...
Loading to database new index Northwind.dbo.[Order Details].[Order Details$Order DetailsOrders] ...
Loading to database new index Northwind.dbo.[Order Details].[Order Details$OrderID] ...
Loading to database new index Northwind.dbo.[Order Details].[Order Details$ProductID] ...
Loading to database new index Northwind.dbo.[Order Details].[Order Details$ProductsOrder Details] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$CustomerID] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$CustomersOrders] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$EmployeeID] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$EmployeesOrders] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$OrderDate] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$OrdersShippers] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$ShippedDate] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$ShippersOrders] ...
Loading to database new index Northwind.dbo.[Orders].[Orders$ShipPostalCode] ...
Loading to database new index Northwind.dbo.[Products].[Products$CategoriesProducts] ...
Loading to database new index Northwind.dbo.[Products].[Products$CategoryID] ...
Loading to database new index Northwind.dbo.[Products].[Products$ProductName] ...
Loading to database new index Northwind.dbo.[Products].[Products$ProductsCategories] ...
Loading to database new index Northwind.dbo.[Products].[Products$SupplierID] ...
Loading to database new index Northwind.dbo.[Products].[Products$SuppliersProducts] ...
Loading to database new index Northwind.dbo.[Suppliers].[Suppliers$CompanyName] ...
Loading to database new index Northwind.dbo.[Suppliers].[Suppliers$PostalCode] ...
Loading to database new table Northwind.dbo.[Order Details] foreign keys ...
Loading to database new table Northwind.dbo.[Orders] foreign keys ...
Loading to database new table Northwind.dbo.[Products] foreign keys ...
Loading to database new table Northwind.dbo.[Categories] check constraints ...
Loading to database new table Northwind.dbo.[Customers] check constraints ...
Loading to database new table Northwind.dbo.[Employees] check constraints ...
Loading to database new table Northwind.dbo.[HRActions] check constraints ...
Loading to database new table Northwind.dbo.[Order Details] check constraints ...
Loading to database new table Northwind.dbo.[Orders] check constraints ...
Loading to database new table Northwind.dbo.[Products] check constraints ...
Loading to database new table Northwind.dbo.[Shippers] check constraints ...
Loading to database new table Northwind.dbo.[Suppliers] check constraints ...
Load operation is complete.
Migrating data...
Analyzing metadata...
Preparing table Northwind.[Categories]...
Migrating data for the table Categories from the database Northwind...
Data migration complete: 8 rows of 8 migrated.
Preparing table Northwind.[Customers]...
Migrating data for the table Customers from the database Northwind...
Data migration complete: 91 rows of 91 migrated.
Preparing table Northwind.[Employees]...
Migrating data for the table Employees from the database Northwind...
Data migration complete: 9 rows of 9 migrated.
Preparing table Northwind.[HRActions]...
Migrating data for the table HRActions from the database Northwind...
Data migration complete: 0 rows of 0 migrated.
Preparing table Northwind.[Order Details]...
Migrating data for the table Order Details from the database Northwind...
Data migration complete: 2155 rows of 2155 migrated.
Preparing table Northwind.[Orders]...
Migrating data for the table Orders from the database Northwind...
Data migration complete: 830 rows of 830 migrated.
Preparing table Northwind.[Products]...
Migrating data for the table Products from the database Northwind...
Data migration complete: 77 rows of 77 migrated.
Preparing table Northwind.[Shippers]...
Migrating data for the table Shippers from the database Northwind...
Data migration complete: 3 rows of 3 migrated.
Preparing table Northwind.[Suppliers]...
Migrating data for the table Suppliers from the database Northwind...
Data migration complete: 29 rows of 29 migrated.
Data migration operation has finished.
9 table(s) successfully migrated.
0 table(s) partially migrated.
0 table(s) failed to migrate.
Linking tables...
Analyzing metadata...
Preparing mdb-file Northwind...
Preparing table Northwind.[Categories]...
Preparing table Northwind.[Customers]...
Preparing table Northwind.[Employees]...
Preparing table Northwind.[HRActions]...
Preparing table Northwind.[Order Details]...
Preparing table Northwind.[Orders]...
Preparing table Northwind.[Products]...
Preparing table Northwind.[Shippers]...
Preparing table Northwind.[Suppliers]...
Starting Phase #0
Processing table '[Categories]' in file 'Northwind'... ...
Linking & backing up table 'Categories' from database 'Northwind'...
Processing table '[Customers]' in file 'Northwind'... ...
Linking & backing up table 'Customers' from database 'Northwind'...
Processing table '[Employees]' in file 'Northwind'... ...
Linking & backing up table 'Employees' from database 'Northwind'...
Processing table '[HRActions]' in file 'Northwind'... ...
Linking & backing up table 'HRActions' from database 'Northwind'...
Processing table '[Order Details]' in file 'Northwind'... ...
Linking & backing up table 'Order Details' from database 'Northwind'...
Processing table '[Orders]' in file 'Northwind'... ...
Linking & backing up table 'Orders' from database 'Northwind'...
Processing table '[Products]' in file 'Northwind'... ...
Linking & backing up table 'Products' from database 'Northwind'...
Processing table '[Shippers]' in file 'Northwind'... ...
Linking & backing up table 'Shippers' from database 'Northwind'...
Processing table '[Suppliers]' in file 'Northwind'... ...
Linking & backing up table 'Suppliers' from database 'Northwind'...
Link & back up complete
No comments:
Post a Comment