SQL Server Performance

How Migrate from MS Access to SQL Server 2005?

Discussion in 'SQL Server 2005 General Developer Questions' started by forums_4m, May 3, 2008.

  1. forums_4m New Member

    Hi SQL Team,Data migration from MS access to Sql server 2005.In client having existing system is MS Access. So I want to migration MS Access system to SQL server 2005.Let suppose there MS Access one table having 10 fields.That table data i need migrate in system (sql server 2005), but the field name are different & sql server few fields are extra suppose 15 fields or vise versa.So can any one help me out, how to migrate the MS access to sql server system?Please give me if any one the script or step do this.Thanks & regards
  2. madhuottapalam New Member

    You may check the Migration Assistant tool which can be used to migrate Access to SQL Server 2005. But in your case, SSIS may be good enough. You may need to create a SSIS pack which Extract ,transform and load the data to sql server 2005. You can map the column in SSIS package. But if you are having Express edition SSIS is not available in that edition
    http://www.microsoft.com/sql/solutions/migration/default.mspx
    Madhu

Share This Page