November 2, 2015 at 2:27 pm
Trying to find out some tools that would allow a comparison of data in SQL Server and Oracle. Please provide the name, description and pros/cons of some reliable and reasonably priced tools.
Thanks in advance.
November 2, 2015 at 3:10 pm
HookSqlDba7 (11/2/2015)
Trying to find out some tools that would allow a comparison of data in SQL Server and Oracle. Please provide the name, description and pros/cons of some reliable and reasonably priced tools.Thanks in advance.
That would be tricky in even the simplest of situations. There are some challenges in mapping datatypes across the two systems.
You would be far more likely to get some responses to this if your post didn't sound like "hey do this research for me and here is the list of things I want". What have you found? What are the pros/cons you found in your research? What do you consider reasonably priced?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 3, 2015 at 7:03 am
Thanks Sean. Yes, I am going to do my own research. Maybe I should have worded it "Does anyone have any experience with such tools? Would you be willing to share your experiences? What should I be aware of based on your experiences? I DO NOT have any experience with such tools. So, I am trying to start somewhere; on a task that I know is coming down the pipe. Please share your experiences. And I will consider that with what I find through my research.
Again, thanks in advance.
November 3, 2015 at 7:50 am
at my last place where we supported Oracle and SQL for an applications RDBMS, we had a specific set of rules to map equivalents structures at a table level. it took a while to build that logic up.
i built a pair of procedures that scripted a SQL table to a specific SQL syntax, and a companion proc that that scripted a SQL table to it's Oracle equivalent.
some of the rules were:
datatypes pretty much map the way this document reads: we had our own exceptions: we pretty much made anything int/tinyint smallint NUMBER(10) for ease of use.
http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm
an SQL identity column became a sequence and and insert trigger. that made specific rules on trigger name and sequence name related tot eh target table.
indexes never got marked with the CLUSTERED keyword
oracle thinks a column with a default is not null, so when scripted, we had to take that into consideration.
we had a package(oracles group of related procedures) we found on the internet that supported the same syntax structure for DATEADD and DATEDIFF, except constants like mm wk etc had to be in single quoteslike 'mm' 'wk' (Oracle DATEADD('dd',7,ColumnName)
Lowell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply