Devart Forums

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?

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?

Yes, thank you. We got it resolved.