SQL Server Performance

Importing MS Access

Discussion in 'SQL Server 2005 General Developer Questions' started by pricec, Mar 27, 2007.

  1. pricec New Member

    Warning: Newby here <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />I am trying to import an access database into SQL 2005, but it is painfully slow (as in taking 6 hours). I am running SQL server 2005 on a Dell server under Win 2003.<br />I can run the import on a WinXP PC with SQL 2005 installed and it is fast (1/2 hr) to do the import.<br />Can anyone give me a start as to where to look to fix the prob ?<br /><br />Craig
  2. dineshasanka Moderator

    before importing, so a comapct operation on MS Access database

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page