USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
Welton3
Posts: 23
Joined: Thu 04 Sep 2014 15:36

USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...

Post by Welton3 » Tue 06 Aug 2019 21:01

In Oracle, we store boolean values in a column of type CHAR(1) with a 'T' or an 'F'. Migrating to SQL Server, we would like to store boolean values in BIT type columns. We are using OracleLoader and SqlLoader components to load the data from Oracle, and then write it to SQL Server.

What is the best way to convert the CHAR(1) values to BIT values during the transfer?

Shalex
Site Admin
Posts: 9301
Joined: Thu 14 Aug 2008 12:44

Re: USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...

Post by Shalex » Wed 07 Aug 2019 16:37

OracleLoader is used for loading data INTO Oracle Server. You can retrieve data FROM Oracle Server with OracleDataReader. If the CHAR(1) value is 'T', assign SqlLoader["BIT_column"] to 1 (and 0 in case of 'F').

Is that what you need?

Welton3
Posts: 23
Joined: Thu 04 Sep 2014 15:36

Re: USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...

Post by Welton3 » Fri 09 Aug 2019 15:31

Yes, thank you. We got it resolved.

Post Reply