Once again, SQL Server 2008 lands a flying kick to Oracles hydra like heads.. or kicks...whatever. In a move that it both stunning and flavored with awesomesauce, SQL Server has made a way to replicate from Oracle to SQL. SQL can register the Oracle instance, install some objects (tables, triggers, normal replication stuff) and then watches for changes. SQL acts as the distributor of the Oracle instance.
I have ran through the setup multiple times just to get the feel and try out different options. Guess what kids, it just plain WORKS.
For those of you asking, "but your DBAness, why would we do such a thing?" the answer is simple. Because sometimes we have to.
Subscribe To
Posts
Comments
About Me
- Matt D
- West Jordan, UT, United States
- I have been working with databases for almost 10 years. Starting out with database migrations and installation of MS SQL Server 6.5. I have worked in various industries over these years and have found a great fondness for SQL Server. I am now a Database Architect for a healthcare company here in Utah and find myself in the unusual position of working with Oracle. I hope to share some fun stories, tricks and tips and some of the pitfalls I find going through this journey.
No comments:
Post a Comment