I've been developing an Application in Access 2010 for a few weeks and I've just used SSMA to migrate the tables only to SQL Server 2008. For the most part things work but I have 2 questions ..
1. I went to some trouble to draw the Relationship disgram in Access. Now I don't see table connections - is that diagram invalid now? Referential integrity seems to be working - any comments?
2. Are there any tricks I should be aware of before I migrate? I already changed settings for dates and had to update some code to use the"dbSeeChanges" option when writing to a recordset. I also noticed that the error handling has changed a little too?
Am I crazy to attempt this or should I do all the table design in SQL to start with (not strong at that) .. Mark