Adobe Photoshop Lightroom catalog conversion between platforms

Since PS LR is using an SQLite database it can be manipulated to go between PC and MAC. The basic scenario is:
- pictures are stored in d:\my documents\my pictures on the pc
- ligthroom dir is d:\my documents\my pictures\lightroom on the pc
- pictures are stored in /Users/_username_/Pictures the mac
- ligthroom dir is /Users/_username_/Pictures/lightroom on the mac

Replace _username_ with your actual username on the mac. Adjust directory length according to path differences in substr functions.

From PC to MAC:
update AgLibraryRootFolder
set absolutePath = '/Users/_username_/Pictures/'||substr(absolutePath,29,1000)
where absolutePath like ('D:%');

update AgLibraryRootFolder
set absolutePath = Replace(absolutePath,'\','/');

update AgLibraryFile
set robustRepresentation = 'A'
where robustRepresentation like ('W%');

update Adobe_variablesTable
set value = '/Users/_username_/Pictures/' where name = 'AgImportDialog_destinationFolderPath';

update Adobe_variablesTable
set value = '/Users/_username_/Pictures/Backups' where name = 'AgImportDialog_backupDownloadFolder';

update Adobe_variablesTable
set value = '/Users/_username_/Pictures/Backups' where name = 'backupDownloadFolder';

update Adobe_variablesTable
set value = '/Users/_username_/Pictures/'||substr(value,29,1000) where name = 'Adobe_lastScannedCatalogPath';

update Adobe_variablesTable
set value = Replace(value,'\','/') where name = 'Adobe_lastScannedCatalogPath';

update Adobe_variablesTable
set value = '/Users/_username_/Pictures/' where name = 'AgImportDialog_missing_copyToPath';

From MAC to PC (not tested yet):
update AgLibraryRootFolder
set absolutePath = 'D:\My Documents\My Pictures\'||substr(absolutePath,23,1000)
where absolutePath like ('/Users/_username_%');

update AgLibraryRootFolder
set absolutePath = Replace(absolutePath,'/','\');

update AgLibraryFile
set robustRepresentation = 'WD:\My Documents\My Pictures\'||substr(absolutePath,23,1000)
where robustRepresentation like ('A');

update Adobe_variablesTable
set value = ''D:\My Documents\My Pictures\'' where name = 'AgImportDialog_destinationFolderPath';

update Adobe_variablesTable
set value = ''D:\My Documents\My Pictures\'Backups' where name = 'AgImportDialog_backupDownloadFolder';

update Adobe_variablesTable
set value = ''D:\My Documents\My Pictures\'Backups' where name = 'backupDownloadFolder';

update Adobe_variablesTable
set value = ''D:\My Documents\My Pictures\''||substr(value,29,1000) where name = 'Adobe_lastScannedCatalogPath';

update Adobe_variablesTable
set value = Replace(value,'/','\') where name = 'Adobe_lastScannedCatalogPath';

update Adobe_variablesTable
set value = ''D:\My Documents\My Pictures\'' where name = 'AgImportDialog_missing_copyToPath';


You can use SQLite Admin from http://sqliteadmin.orbmu2k.de/ to do this. It can only run one statement at a time so paste the complete text relevant to your direction in the sql text box. Press F9 to execute then remove the topmost statement. Repeat until done.

If you're not sure just start over again as you had a backup, right?