phinx icon indicating copy to clipboard operation
phinx copied to clipboard

Ms Sql Server with Database case sensitive

Open rudy1976s opened this issue 7 years ago • 1 comments

I have the need to run migrations using this tool on a MS SqlServer ( Microsoft Dynamics Nav) which is case sensitive. I cannot do anything because I have the following error at the very beginning, even trying to get migration status:

Error: [PDOException] SQLSTATE[42S02]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'information_schema.tables' ... in [...] vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php on line 349

That table is in UPPERCASE on Database.

Is there any workaround ?

I am using cakephp Version 3.6.1 SqlServer 2016

Thank you Rudy

rudy1976s avatar May 03 '18 12:05 rudy1976s

PR welcome for a fix.

dereuromark avatar Apr 11 '20 07:04 dereuromark