René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"unsure.sql script need many correction","articleBody":"In my case I can see queries in unsure.sql (mostly view in my case) are almost same as it is SQL Dump file. Due to this unsure.sql script has many issues and giving error. Do I need to validate each and every query in this script and correct it manually. \r\n\r\nSample SQL Dump file  is attached \"sql_server_dump_TestDB.zip\". After converting this, I had to find and replace following 4 strings, then unsure.sql could work. This is just a sample dump SQL file\r\n\r\nString: b1.C1 +  '|'  + b2.C1\r\nReplaced With: concat(concat(b1.C1, '|'), b2.C1) AS C1\r\n\r\nString: b1.C1 +  '|'  + ISNULL(b2.C1, '')\r\nReplaced With: concat(concat(b1.c1, '|'), COALESCE(b2.c1::text, ''::text)) AS c1\r\n\r\nString: CAST(T97531Id AS VARCHAR(256))+ '-' +C1\r\nReplaced With: concat(concat(T97531.T97531Id, '-'), T97531.C1) AS c1\r\n\r\nString: convert(NVARCHAR(15),CO11011) + ';' + convert(NVARCHAR(15),CC11011) + ';' + C11011\r\nReplaced With: concat(concat(concat(concat(\"substring\"(B4102.co11011::text, 1, 15), ';'), \"substring\"(B4102.cc11011::text, 1, 15)), ';'), B4102.c11011)\r\n\r\n[sql_server_dump_TestDB.zip](https://github.com/dalibo/sqlserver2pgsql/files/3390973/sql_server_dump_TestDB.zip)\r\n","author":{"url":"https://github.com/manishdwivedi02","@type":"Person","name":"manishdwivedi02"},"datePublished":"2019-07-15T05:59:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/107/sqlserver2pgsql/issues/107"}