Post reply

Migrating data from SQL server to MS Access and Oracle

  • February 10, 2009 at 1:20 am

    #130797

    Hi,

    I'm trying to decide the best techniques of how to migrate data from both an MS Access database and Oracle database into a SQL server 2005 database. Have you any ideas how I can handle this? And what issues could occur by this process? And what are the ways I can prevent or avoid such issues occuring?

    Many Thanks

    Tim

  • February 10, 2009 at 6:33 am

    #941136

    To import data from other sources you can use SSIS. Any issues that can occur depend on your systems and needs. There is no way to tell you about it up front. Just start creating a SSIS-package and test it.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply