x

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 '10 at 11:55 AM in Default

Kori gravatar image

Kori
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 '10 at 12:47 PM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

(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 '10 at 12:52 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.5k 19 22 32

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 '10 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 '10 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x375
x58

asked: Apr 12 '10 at 11:55 AM

Seen: 1799 times

Last Updated: Apr 12 '10 at 12:09 PM