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.

more ▼

asked Apr 12, 2010 at 11:55 AM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Apr 12, 2010 at 12:47 PM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 12, 2010 at 12:52 PM

avatar image

15.6k 22 57 38

Timothy - you can actually use SSMA to find changed data? I have never used it so have no idea, I am simply very surprised!

Apr 12, 2010 at 03:04 PM Fatherjack ♦♦

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.

Apr 12, 2010 at 03:59 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 12, 2010 at 11:55 AM

Seen: 2179 times

Last Updated: Apr 12, 2010 at 12:09 PM

Copyright 2018 Redgate Software. Privacy Policy