question

Kori avatar image
Kori asked

SSMA 4.0 for Oracle

Hi Team,

I have extracted initial data from Oracle to Sql Server, and the business still uses Oracle Database. To load the delta data from oracle to Sql server 2008, I would like to know if I can use SSMA 4.0 to migrate the delta data and schedule it as a SQL job.

Please provide your inputs.

sql-server-2008oraclemigration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Fatherjack avatar image
Fatherjack answered

I doubt the SSMA will fit your needs and you will need to build something in SSIS to extract the data from Oracle, maybe as described here: http://www.microsoft.com/sqlserver/2008/en/us/ssis-oracle.aspx

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image
TimothyAWiseman answered

In general, yes, you should be able to. You could instead add Oracle as a linked server and then do the data transfer through pure T-SQL. You can also create an SSIS package to link to Oracle and pull the data over and then schedule running that package as a SQL job.

When dealing with multiple database applications there can be complications so working out the details may prove challenging, but it can be done.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
I believe you can. I have never actually done it. I would use either a linked server or SSIS package to keep them in synch after the initial set up. You could always just repeatedly pull everything over of course with SSMA in the worst case, but to call that ineffecient would be an understatement.
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
Timothy - you can actually use SSMA to find changed data? I have never used it so have no idea, I am simply very surprised!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.