Browse by Tags

Oracle DATE vs SQL DATE

During the development of a simple (or so we thought ) SSIS task a strange error came up: we had a dbtimestamp column from Oracle which we had to load into a SQL Server ( 2005! ) table. It was a transaction date so by default there shouldn't have been any problem with it. By default. But life's...

Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Tue, Mar 31 2009
Migrating from Oracle to Microsoft SQL Server - starting points

The SQL Server engine does not work in the same way as the Oracle one; there are lots of differences and also lot's of different "theory" you need to understand that is quite different from Oracle. A good starting point in terms of a like for like discussion is in this paper from Microsoft...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Fri, May 30 2008
Oracle documentation - you think we have it bad.

I'm researching some comparisons between Oracle and SQL Server to counter a crib sheet an Oracle DBA has knocked up (more on that), for instance what is the equiv of a tablespace or system trigger in SQL Server. Looking at SQL Server books online and the MSDN online version of bol -> http://msdn2...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Thu, Aug 23 2007

Page 1 of 1 (3 items)

SQL Server Blogs