This is a very useful introduction and very helpful. If you have any useful links it would be great if you could share them at the end or in the youtube video notes.
It is clear that the Access 2010 upsizing wizard should be used if possible and the following links expand on the reasons you gave.
Of particular note in the first link is how the wizard handles the following (as I think the method you present may not give the same results):
- converting Access field names to legal SQL Server field names
- Validation rules (triggers are created),
- Default Values (er, it does something I don't understand yet.),
- the table properties "Description, Caption, Format, InputMask, and DecimalPlaces." which I think may "get lost" using the method you demonstrate.
- why it gives PK indexes a name beginning with "aaaaa" (As Access chooses the index to use based on the alphabetical order of the index name - which I find hard to believe)
Both links are about olrder version of Access, so they may be dated, however, there doesn't seem to be more recent versions of these articles out there. The second link, in particular, gives some good info but gets pretty heavy, however, I found it useful to better understand issues that can arise.
1 [Move Access data to a SQL Server database by using the Upsizing Wizard](https://support.office.com/en-ca/article/Move-Access-data-to-a-SQL-Server-database-by-using-the-Upsizing-Wizard-5d74c0df-c8cd-4867-8d07-e6e759d72924?ui=en-US&rs=en-CA&ad=CA&fromAR=1
2 [Optimizing Microsoft Office Access Applications Linked to SQL Server](https://msdn.microsoft.com/en-us/library/bb188204.aspx
I also read this about Connect strings, which intrigues me:
In a module, you can define a formatted connect string that specifies connection information. A connect string passes the connection information directly to the ODBC Driver Manager, and it helps simplify your application by removing the requirement that a system administrator or user first create a DSN before using the database.
Thanks for the massive and contribution you are making to my learning!
I hope this might be useful.