LOAD DATABASE
FROM mssql://***:***@***:1433/AdventureWorks2019
INTO postgresql://***:***@***:5432/***
WITH include drop, create tables, no truncate,
create indexes, reset sequences, foreign keys
CAST type udt to text drop default drop not null
before load do $$ drop schema if exists dbo cascade; $$
;
[x] pgloader output you obtain
......
SIMPLE-ERROR: not supported type SYB-MSUDT
An unhandled error condition has been signalled: not supported type SYB-MSUDT
What I am doing here?
not supported type SYB-MSUDT
pgloader: mem.c:1202: tds_free_connection: Assertion `conn->in_net_tds == NULL' failed.
fatal error encountered in SBCL pid 3117709(tid 0x7efc9d84f700):
SIGABRT received.
Welcome to LDB, a low-level debugger for the Lisp runtime environment.
ldb>
[x] data that is being loaded, if relevant
No data loaded
[ ] How the data is different from what you expected, if relevant
[x] pgloader --version
[x] did you test a fresh compile from the source tree?
Yes, I've tested, but still not working
[x] did you search for other similar issues?
Yes, I searched a lot, but not found any error like this
[x] how can I reproduce the bug?
Just download the free MS SQL database from Microsoft: AdventureWorks2019, restore it, and try migrate it from a MS SQL server. https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms