Re: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 22 May 2007 22:24:12 +0000 (UTC)
James Appleby (james.w.appleby@xxxxxxxxx) writes:
I am trying to use the Import and Export Data tool that comes with SQL
Server 2000 to transfer data from SQL Server into Oracle 9i. (I'm not
migrating away from SQL Server, the software I'm writing supports both
and I need to duplicate data for testing purposes.) When using the
tool, I can seem to connect to both the source and destination
databases, however it won't copy over the data. It reports an error
with a field of type TIMESTAMP. Looking through the previous screens,
I've found it believes the column is NUMBER(11,0) rather than a date
time value. Does anyone know why this is and how I can resolve the
problem so that the data can be copied, please?
The timestamp data type has nothing to do with date and time. The
correct interpretation is binary(8). I suspect that the value is of
little interest on Oracle, since timestamp is a very special data type:
SQL Server automatically updates such a column when a row is updated
with a database-unique monotonically growing value. It's main purpose
is to provide a simple solution for optimistic concurrency. Except that it
tells in which rows were updated, it carries very little amount of
real information.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- From: James Appleby
- Re: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- References:
- Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- From: James Appleby
- Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- Prev by Date: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- Next by Date: Re: Dumping sql server
- Previous by thread: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- Next by thread: Re: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
- Index(es):
Relevant Pages
|
