sql-server-migration-assi

Can SSMA for migrating Access databases to SQL Server 2005 be automated?

I need to migrate Access databases to SQL Server 2005. Since this needs to be done from within a setup so that a customers' installation is transparently migrated to SQL Server 2005, I wonder if it is possible to automate the SSMA toolkit from Microsoft. ...

MS-Access Add Additional Linked Tables

I have an MS-Access database that was converted to use SQL Tables using the "Microsoft SQL Server Migration Assistant 2008 for Access" (aka SSMA) and created linked tables (so the MS-Access interface still works but is linked to SQL Tables). Modifying those tables has been no problem (modify in SQL, use the Linked Table Manager in MS-Ac...

Migrate Access 2007 Database Application to SQL Server 2005 using SSMA - Issues...

I have managed to get SQL Server 2005 Express up and running on my computer Ok in order to do some testing before trying this in the "Real World". I have a fairly large MS Access 2007 Database application I need to migrate to SQL Server retaining the "Front End" as the user interface. (The app' is already a "split" database with a Fr...

Sql Server Migration tool not quite working

I was finally able to get the schema correct on both sides. Im ready to run the final step and.... Data migration started.... Data migration failed... System.Data.OracleClient requires Oracle client software version 8.1.7 se I have done ever suggestion on google known to man 1) install oracle client 10.2 and remove 10.1 2) add "authent...

Converting plain text in SQL to hyperlink in Access

Hello, I've just started a new job my first since leaving University and as part of this my first task is to convert a wholly Access 2003 database to an Access front-end, SQL back-end. The Access database consists of a series of front end forms to add or review staff data, as part of this there is hyperlinks pointing to a photograph of ...

SSMA timestamp. What's it for, how is it used?

I rencently used the SQL Server Migration Assistant to import a database into SQL Server 2005. I noticed that a number of tables that were imported have been ammended with a new column called SSMA_timestamp. Can anyone tell me what this is for and how it would be used? ...

SSMA upgrade makes forms read-only?

I have a database that I have recently upgraded via SSMA to use SQL Server 2005. If I open a form that is bound to a table, it will display the data from the table; however, I am unable to edit the form and save the information. Simply typing in a textbox does nothing. I have noticed that the Access DB now has extra "tables" that begi...