schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.62k stars 200 forks source link

12.2.7 - Cannot deserialize catalog (can't read offline db) #277

Closed jmbeach closed 4 years ago

jmbeach commented 4 years ago

Issue

After serializing a database using the following style command:

--server=sqlserver ...my-connect-info... --info-level=maximum --port=49903 --command=serialize -o mydb.yaml --schemas=<my-schema>

I cannot query the offline db:

--server=offline --database=mydb.yaml --info-level=maximum --password= --command=schema

I get the error: Error: Cannot deserialize catalog: invalid stream header: 2D2D2D0A

I also tried with JSON. Same error.

Logs: debug-logs.zip

Environment

SchemaCrawler version 16.2.7 Java version 1.8.0_221 Windows 10 Microsoft SQL Server

sualeh commented 4 years ago

Deserialization is only supported with the Java serialization format, and not with JSON and YAML.

jmbeach commented 4 years ago

sorry I missed that

sualeh commented 4 years ago

@jmbeach - Jared, no worries. 😄