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?
USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...
Re: USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...
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?
Is that what you need?
Re: USING LOADER TO MIGRATE FROM ORACLE TO SQL SERVER...
Yes, thank you. We got it resolved.