Bamboo data migration from Postgres to MS SQL Server - tinyInt as boolean

[Justin Bleach]

We're attempting to migrate Bamboo databases from postgres to SQL Server. We noticed that true/false in Postgres needs to be converted to a tinyInt in SQL Server.

What should the values map to? True = 1 and False = 0 ? We tried doing that and are seeing a couple different errors in the log file:

'Retrieving MANAGER-CIM' threw org.apache.commons.configuration.ConversionException: 'cleanWorkingDirectory' doesn't map to a Boolean object, aborting.

and

org.apache.commons.configuration.ConversionException: 'triggers.defined' doesn't map to a Boolean object

[Justin Bleach · Accepted solution]

During our conversion we accidentally changed some false values to "false" in the build_dscription table and that's where these errors came from.

It appears our assumption to use 1-0 for True-False respectively worked.

[kiran jonnalagadda]

better way to do this is using bamboo xml export and import feature.

you can export an entire site xml backup and restore it back after connecting to mssql database