Friday, March 17, 2006

Alas, going back to Oracle

If you ever need to convert a database from SQL Server to Oracle - one thing you will notice is that Oracle does not seem to have a GUID datatype - you actually need to store it in a RAW(16) column - here is some other stuff you have to watch:
  • Watch out for Oracle sequential guids

  • Oracle data provider for .Net

  • Oracle.DataAccess issues - some cautionary tales

  • Mapping .NET Framework Data Provider Data Types to .NET Framework Data Types
  • No comments: