Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-9725

MSSQL Schema is not azure compatible

    Details

      Description

      The T-SQL schema builder adds "ON" statements to the create table query, specifying the use of the default partition scheme. Azure SQL however does not support that statement.
      http://msdn.microsoft.com/en-us/library/ee336258.aspx

      Evaluate whether it's OK to remove the ON statements from the schema or if we need a new schema for azure.

        Activity

        Hide
        Kellanved Kellanved [X] (Inactive) added a comment -

        Preliminary fix.

        Show
        Kellanved Kellanved [X] (Inactive) added a comment - Preliminary fix.
        Hide
        Oleg Oleg [X] (Inactive) added a comment -

        Commit message needs to be adjusted for current guidelines, need a pull request also.

        Show
        Oleg Oleg [X] (Inactive) added a comment - Commit message needs to be adjusted for current guidelines, need a pull request also.
        Hide
        bibin bibin [X] (Inactive) added a comment -

        We removed 'ON PRIMARY' statement from the mssql script as it’s not supported in SQL azure. The 'ON PRIMARY' statement in specified in the DDL denotes the "file group" associated with that table. In SQL server there are two types of file groups:
        a. Primary file group
        b. User defined file group

        The primary file group contains the primary data file and any other files not specifically assigned to user defined file group. In PHPBB-SQL-Schema we are not using any user defined file group, so by default all tables belongs to PRIMARY file group. This means it's usually useless and can be safely removed from the script.

        Show
        bibin bibin [X] (Inactive) added a comment - We removed 'ON PRIMARY' statement from the mssql script as it’s not supported in SQL azure. The 'ON PRIMARY' statement in specified in the DDL denotes the "file group" associated with that table. In SQL server there are two types of file groups: a. Primary file group b. User defined file group The primary file group contains the primary data file and any other files not specifically assigned to user defined file group. In PHPBB-SQL-Schema we are not using any user defined file group, so by default all tables belongs to PRIMARY file group. This means it's usually useless and can be safely removed from the script.

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            Kellanved Kellanved [X] (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development