I build web apps with a bunch of different frameworks (.NET MVC, SharePoint, Drupal, ColdFusion) using bunch of different datastores (Oracle, SQL Server, MySQL, some CouchDB). I'm also a big fan of continuous integration testing and devops.

Notes On Migrating Oracle 11g Tables to SQL Server 2008R2

less than 1 minute read


Assuming you have 3 boxes total:
-          Oracle Severs 11g with tables you want to copy
-          A SQL Server 2008 server that allows remote connections via windows auth (password auth should work fine too)
-          A workstation with Oracle 11g client and SQL Server 2008 client

Install Clients on Workstation
-          Install Oracle 11 client
o   Make sure you install the same version of the Oracle client on your workstation that is being used on the Oracle DB server. 
o   Select the Administrator option when you perform the client install. ( The oracle .NET provider and the OLE DB provider are required )
o   After the client install, make sure you update the TNSNAMES file. The import process will use this to make the connection to the oracle server.
-          Install the SQL Server 2008 management tools including the SSIS option (the SSIS part might not be required)
 

Run the SQL Server 2008R2 import/export tool

You May Also Enjoy

Node.js web app experiments

1 minute read

Needed a break from all the .NET and Coldfusion goo I’ve been dealing with at work. Started working on a mobile-first workout tracking app using only free to...