none
Database Question RRS feed

  • Question

  • <p><a name="OLE_LINK1"><span>Hello,</span></a></p><p><span><span>I’m using your SSMA for Access software or MS SQL Server Migration Assistant for Access to convert an MS Access 2010 database into a SQL Server 2008 database.<span>&nbsp; </span>The database is a split one.<span>&nbsp; </span>So, I’m only concerned about the tables.mdb file being converted.<span>&nbsp; </span>I have created an ODBC connection (DSN=DSN1) to connect the SQL Server to the MS Access 2010 frontend.mdb file (contains forms, queries, reports, etc).<span>&nbsp; </span>All was successfully created.</span></span></p><p><span><span>My question is regarding making certain “Project Settings” before performing the migration.<span>&nbsp;&nbsp; </span>When I have done previous conversions using SSMA for Access, I have left the “Project Settings” set to their default values.<span>&nbsp;&nbsp; </span>I noticed that if I have a table in the MS Access database called ‘tblABC’, then once I do the conversion the table in SQL Server is ‘dbo.tblABC’ (which is just fine).<span>&nbsp;&nbsp;&nbsp; </span>However, when I go to my MS Access frontend.mdb , the same table is called ‘dbo_tblABC’ via the DNS in MS Access Linked Table Manager.</span></span></p><p><span><span>Question:<span>&nbsp; </span>How can I set the “Project Settings” (before I perform the migration using SSMA) so that in Access there will be no table linked to SQL Server now called ‘dbo_tblABC’, but will still have its original name as in MS Access ‘tblABC’ while still being a linked table to SQL Server?</span></span></p><p>Thanks for any assistance.<span></span></p>

    Hello,
    I’m using your SSMA for Access software or MS SQL Server Migration Assistant for Access to convert an MS Access 2010 database into a SQL Server 2008 database.  The database is a split one.  So, I’m only concerned about the tables.mdb file being converted.  I have created an ODBC connection  to connect the SQL Server to the MS Access 2010 frontend.mdb file (contains forms, queries, reports, etc).  All was successfully created.
    My question is regarding making certain “Project Settings” before performing the migration.   When I have done previous conversions using SSMA for Access, I have left the “Project Settings” set to their default values.   I noticed that if I have a table in the MS Access database called ‘tblABC’, then once I do the conversion the table in SQL Server is ‘dbo.tblABC’ (which is just fine).    However, when I go to my MS Access frontend.mdb , the same table is called ‘dbo_tblABC’ via the DNS in MS Access Linked Table Manager.
    Question:  How can I set the “Project Settings” (before I perform the migration using SSMA) so that in Access there will be no table linked to SQL Server now called ‘dbo_tblABC’, but will still have its original name as in MS Access ‘tblABC’ while still being a linked table to SQL Server?
    

    • Edited by cdixon24 Friday, May 2, 2014 8:09 PM
    Friday, May 2, 2014 8:07 PM

Answers

  • Hello,

    If you make a right click on the Access database you are connected using SSMA Project, then just select the unlink tables option.


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, May 2, 2014 8:28 PM
    Moderator