Monday, July 28, 2008

I hate Oracle DB

I HATE ORACLE. I REALLY REALLY HATE ORACLE. It's difficult to connect to, difficult to pull data from, difficult to see the schema. And Microsoft's SSMA doesn't make it any easier to actually migrate - the documentation is a complete lauch, there's no steps, no directions, just information on how people migrate not using the tool. Oracle requires me to download a FIVE HUNDERED MEG download just to use the ODBC driver, and the OLE driver is a complete farce. I just want to grab 1.5 GB of data from an Oracle server and pull it into SQL Server where I can actually get work done. We're having to export as CSV files (!!) and pull it back again in SQL because even Microsoft's tool can't see to actually migrate any schema or data reliably, and the memory leak is really getting annoying. I'm gonna blow my stack with this.

No comments: