I have just used the SSMA tool from MS for server 2008 and was able to migrate and link the tables. My question is-
I am using test data-so I put in test data for the migration and link of table. I run a query using SQL and see the data. I then add new test data after the migration but do not see it in the SQL tables.
On the Access side of things I see all the original table as being linked and all the SSMA tables the migration created.
I see the new test data in the original tables that are linked but not in the corresponding SSMA tables.
I am a little confused of how data being entered into Access front end is saving to the linked tables but not the SSMA tables or what I have to do to automate this. Hope this makes sense. Just learning the SQL side of things.