February 10, 2012 at 9:23 pm
If I am try to get an Oracle database to replicate to a SQL Server instance, does the Oracle database need to have a primary key.
Does Oracle have an equivalent to SSIS?
February 11, 2012 at 7:10 am
Rowles (2/10/2012)
If I am try to get an Oracle database to replicate to a SQL Server instance, does the Oracle database need to have a primary key.Does Oracle have an equivalent to SSIS?
1- No, it is not "needed" but it is good practice if you want to enforce referential integrity.
2- No.
Having said that, "migration" of your tables and data will be a work in the park - I have done that a zillion times; the fun begins when you try to "migrate" the code. Do yourself a favor, re-write your code from scratch. PL/SQL is a powerful language but be sure you understand how it works, especially packages, before you start.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 11, 2012 at 7:19 am
Does Oracle have an equivalent to SSIS?
yup... Oracle Warehouse Builder. IIRC it requires separate licenses.
More:
http://en.wikipedia.org/wiki/Oracle_Warehouse_Builder
http://www.oracle.com/technetwork/developer-tools/warehouse/overview/introduction/index.html
February 11, 2012 at 12:27 pm
Dev (2/11/2012)
Does Oracle have an equivalent to SSIS?
yup... Oracle Warehouse Builder. IIRC it requires separate licenses.
To a certain extent but not the same...
...if you want to move a table from A to B, on SQL Server you would probably use SSIS while on Oracle you would either use a dblink or expdp/impdp.
...if you want to load data from a flat file, on SQL Server you would probably use SSIS while on Oracle you would use External Tables.
I would agree both SSIS and OWB allow to build ETL processes but products are not the same.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 12, 2012 at 2:20 am
...if you want to move a table from A to B, on SQL Server you would probably use SSIS while on Oracle you would either use a dblink or expdp/impdp.
Other Options: Export Import Utility (which will use SSIS / DTS functionalities internally, transparent to end user)
...if you want to load data from a flat file, on SQL Server you would probably use SSIS while on Oracle you would use External Tables.
Other Options: BULK INSERT, BCP, OPENROWSET etc.
I would agree both SSIS and OWB allow to build ETL processes but products are not the same.
I agree with you. They are not same & I never claimed that (even their vendors don't). They are two different products and offer few functionalities which are common.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply