What is an easy way to migrate Data from MSSQL to PostGresSQL?
I tried to import some work table entries from MSSQL to posgresSQL via a product rule import. I encountered an index sync issue, where creating new work in pega failed, since the initial index after the import was not updated, was still at 1. I don't think a product rule import is the best way to migrate large amounts of work, but didn't work for small amounts either.
Looking for a large way to migrate data from MSSQL to PostGresSQL.
extra credit::.. Anyone know how to fix the postgresSQL sync issue importing work items from MSSQL?