Database Migration from AS400 to SQL Server and Synchronization

• bayapareddy.msbi

  SSC Enthusiast

  Points: 153

  More actions

  March 13, 2014 at 12:46 am

  #305198

  Hi,

  i want to implement Database Migration from AS400 to SQL Server and Synchronization .so i am new to data migration.please help me if any body knows how to implement.

  just i want know some basic requirements to connect as400 and any basic requirements to implement

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  March 13, 2014 at 12:54 am

  #1696666

  bayapareddy.msbi (3/13/2014)

  ---

  Hi,

  i want to implement Database Migration from AS400 to SQL Server and Synchronization .so i am new to data migration.please help me if any body knows how to implement.

  What sort of help do you need? Please ask specific questions & people will help if they can.

  ---

• aaron.reese

  SSChampion

  Points: 13498

  More actions

  March 13, 2014 at 8:12 am

  #1696802

  If memoery serves correctly, DB2 is the native database for AS400. you should be able to get hold of ODBC drivers which will need to be installed on your SQL server (and any development desk/laptops). you will also need read only priveleges for an SQL user account on the DB2 database.