locked
SQL Server Migration Assistant for Access: How to use it? RRS feed

  • Question

  • Hi all,

    I have Microsoft Access 2003 and SQL Server 2005 Express/SQL Server 2005 Management Studio Express in my Windows XP Pro PC. I just downloaded and installed the Microsoft SQL Server Migration Assistant for Access (ssma-foraccess_1.0.389.msi, 7/31/2006, 5.3 MB). But I do not know where the SQL Server Migration Assistant for Access is located now and how to use it to upsize to the .mdb files of my Access 2003 databases to the SQL Server 2005 Management Studio Express as the .mdf for the SQLDataSource.  Please help and give me the detailed instructions/procedures to use the SQL Server Migration Assistant to perform the upsizing task.

    Thanks in advance,

    Scott Chang

    Sunday, September 24, 2006 8:46 PM