René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"-ignore_errors flag for schema conversion as well","articleBody":"Hi Team,\r\nThe current behaviour of the tool is that it errors out during schema conversion if it finds some unknown clause. \r\nExample\r\n```\r\nCannot determine the PostgreSQL's datatype corresponding to hierarchyid. This is a bug\r\n at ./sqlserver2pgsql.pl line 379, \u003c$file\u003e line 690.\r\n\tmain::convert_type('hierarchyid', undef, 'OrganizationNode', 'Employee', undef, 'HumanResources') called at ./sqlserver2pgsql.pl line 1424\r\n\tmain::add_column_to_table('HumanResources', 'Employee', 'OrganizationNode', undef, 'hierarchyid', undef, undef, 'NULL') called at ./sqlserver2pgsql.pl line 1546\r\n\tmain::parse_dump() called at ./sqlserver2pgsql.pl line 3316\r\n```\r\nAnd then it stops here **without providing anything in the output files**. Is there a way to skip/ignore such statements and go ahead with converting the rest? \r\n\r\nThe `-ignore_errors` flag exists for the data side but a similar flag during schema conversion will be a huge help.\r\n\r\nThank You in advance!","author":{"url":"https://github.com/shubham-yb","@type":"Person","name":"shubham-yb"},"datePublished":"2023-02-21T12:59:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/173/sqlserver2pgsql/issues/173"}