Category: C#

ApexSQL

We are currently migrating a given database environment from an external provider on SQL Server 2005 to Oracle 11.2.0.3. While we could use GoldenGate, it is a one time migration for which we don’t need the “big iron” (or cost).…

Simple example of C# program accessing Oracle

Nothing big, just a placeholder for an example of what is in the subject line. //C:\Users\showard>C:\Windows\Microsoft.NET\Framework\v2.0.50727\csc.exe /r:”C:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll” checkConn.cs using System; using Oracle.DataAccess.Client; public class checkConn { public static void Main(String []args){ OracleConnection conn = new OracleConnection(“User Id=biztalk;Password=********;Data Source=fn9dev”); OracleDataReader rdr;…