This small patch adds some logic to allow D5 pathauto installs running on SQL Server. Because SQL Server is lame, it requires the dropping of constraints before you can do anything with columns (like what needs to be done with the variables table "name" column).

Do with this as you wish, just thought I'd offer it up in case others needed it.

CommentFileSizeAuthor
#3 pathauto_node.inc-mssql.patch1.08 KBpcorbett
#3 pathauto_user.inc-mssql.patch1.04 KBpcorbett
pathauto_5.x-2.3_mssql.patch1.96 KBpcorbett

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Title: SQL Server Support » SQL Server Support for Pathauto

I'm not sure that we can do much with this, but I do really really appreciate you providing this patch in general.

Are there any other pathces for the rest of the module or just this one for the installer?

pcorbett’s picture

pcorbett commented

No problem - I understand. It's just for the installer since no other "fancy" SQL was used elsewhere. The whole issue with constraints is a huge annoyance in MSSQL. When I have time to get into D6 & 7, I hope the process is at least a bit more streamlined.

pcorbett’s picture

pcorbett commented
StatusFileSize
new pathauto_user.inc-mssql.patch1.04 KB
new pathauto_node.inc-mssql.patch1.08 KB

Here are two more patches I found were necessary to take care of some MSSQL-specific SQL. The first patch that I had posted only patches the .install file.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Version: 5.x-2.3 » 7.x-1.x-dev
Status: Active » Postponed

This page is now very visible in most search engines when looking for this. I think that anyone looking for it will find it and am therefore marking it postponed for 6.x-2.x.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Postponed » Closed (duplicate)

Merging this issue into #319070: Provide a wrapper for cross-db and cross-field-type concatenation (PosgreSQL) where we're going to take care of all supported db types once and for all.