Notes on video: When upsizing the
exclusion area spots tables like past errors and allows them to be
excluded, there is a whole feature here for say detecting all tables
called TEMPxxx, JohnXXXX and excluding them.
During upsizing you may have spotted a table in SQL Server called ‘UPSIZE_SQLLOG’ this is a log off the upsizing, gives start and end times for data transfer in each table; very useful when upsizing big systems.
Schemas allow you to upsize several access databases to a single sql server database and keep them partitioned under different names, giving you tables called Sales.tblOrders and say Marketing.Leads when you upsized the Sales and then a second Marketing database. Synonyms go with schemas, as without a synonym called tblOrders, you would need to say Sales.tblOrders.