[DBAL-254] SQL Server rename table should use sp_RENAME Created: 11/Apr/12 Updated: 17/Apr/14 Resolved: 08/Jul/12
|Reporter:||Fryderyk Benigni||Assignee:||Benjamin Eberlei|
SQL Server 2008 R2 on windows Server
Whenever DBAL Schema Manager tries to rename a table in sql server 2008 it should use also the sp_RENAME procedure. Otherwise error is thrown.
Apparently a similar issue was fixed for column ALTER Commands as described in the link below, but also the ALTER TABLE command should use sp_RENAME to avoid crash.
Suggested fix for Latest DBAL 2.2
From Line 283:
$queryParts = 'RENAME TO ' . $diff->newName;
To Line 283:
$sql = 'sp_RENAME \'' . $diff->name . '\',\'' . $diff->newName.'\'';
This seems to fix the problem.
Hope this helps
Sorry for my bad english.
|Comment by Benjamin Eberlei [ 08/Jul/12 ]|