Results 1 to 3 of 3

Thread: Data migration froom Ms access to SQL server 2005 express

  1. 02-04-2006, 10:26 AM #1
    BASU
    BASU is offline Registered User
    Join Date
    Feb 2006
    Posts
    3

    Data migration froom Ms access to SQL server 2005 express

    What is the best way to migrate data from MS Access database to SQL Server 2005 database. If the migrationn done through Upsize Wizard in MS Access then it requires to remove the relationship first. Is there any way to migrate the data together the relationship.
    Reply With Quote Reply With Quote
  2. 02-04-2006, 01:12 PM #2
    yogeshsr11
    yogeshsr11 is offline Registered User
    Join Date
    Jan 2006
    Location
    USA
    Posts
    19
    Use DTS. Easy & fast.
    Reply With Quote Reply With Quote
  3. 02-04-2006, 05:23 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    It's SSIS in sql2k5.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules