December 20, 2001 at 2:51 am
Hi,
I want to migrate a database from Oracle 8.0.5 to MS SQL 2000 server.
I created a db in SQL, started DTS with an ODBC connection (admin user,
internal in Oracle)
And selected all the tables to migrate.
When I select the tables, on about half I get the following message when I
select preview:
DTS import/Export Wizard Error
Context: Error calling GetNextRows:
Your provider does not support all the interfaces/methods required by DTS.
When I then select to import the data, about half of my tables are imported.
The others give the following error:
Error at Source for Row number 1.
Errors encountered so far in this task: 1.
All the tables are created but only the tables where there was no error, are
filled.
The rest is created, but the data isn't moved.
Does anyone know what the problem can be?
The database isn't too big, only 100MB, but will grow quickly in the coming
months.
It contains about 75 tables.
Thanks in advance,
Eduard de Vries
Eduard de Vries
December 21, 2001 at 5:39 am
Hi,
I think I figured out where it dies.
The tables which are transferred correctly are the tables only containing character and datetime fields.
The ones which have smallint, etc dy.
Should I change the type to integer to sovle this?
Thanks in advance,
Eduard de Vries
Eduard de Vries
December 21, 2001 at 8:20 am
Worth trying, at least see what happens.
Andy
December 21, 2001 at 10:26 am
January 9, 2002 at 1:54 am
Hi,
it worked.
However I did it only for one table since it took too long.
WIth the OLE driver, not the Oracle driver it worked as well, and I used that.
The only thing which created problems were the stored procedures, but it is all fixed and we are up and running again.
Thanks for the help,
Eduard
Eduard de Vries
Eduard de Vries
January 9, 2002 at 10:49 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply