Post reply

Import Oracle table to SQL Server database

  • October 11, 2010 at 6:29 pm

    #387982

    Hi,

    We have Oracle database and one of tables stores the users information and we need to import those users to SQL Server 2008 table

    Is that possible? how can we archive this?

    Thanks

  • October 12, 2010 at 5:24 am

    #1235404

    the easiest way would be to use the Import/Export from SSMS; before you can do that, you need to have the ability to connect from the SQL server to the Oracle instance; in my shop that means we install the Oracle client tools on the SQL server operating system, and then copy someones existing files for 'tnsnames.ora' to the Admin/network folder to the SQL server's equivalent folder; once we test that connectivity with the known Oracle tools works on the server, we can then use a linked server or the import export wizards to connect and select from oracle tables.

    do you need more details, or is an overview enough?

    i mentioned a linked server, which still requires the connectivity i described above, and that is another option as well, especially if this is something you might need to query different tables, vs importing a single table.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 12, 2010 at 5:34 am

    #1235409

    Also you can download the SQL Server Migration Assistant (SSMA) from Microsofts website.

    This nifty tool allows you to migrate a whole or partial database (ie: just one table) plus data from an Oracle server to a SQL server.

    Just used it the other day and it worked a treat.

    You need an Oracle client on your workstation and a valid login so you can connect to the source oracle db and that's it.

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

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