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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy