sqlserver upgrade sql-script

[Migrated From Jforum.net]

In the current 2.17 Release the upgrade-script for sqlserver was missing.

I changed the mysql-script so that it could be run against a SqlServer2005 ...

Here is my sqlserver (2005) specific upgrade script:


[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

We didn't list sql server as a "trully" suported database for JForum, so that's why there is no upgrade script. Is the SQL Server db running 100%?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael Steil wrote:We didn't list sql server as a "trully" supported database for JForum, so that's why there is no upgrade script.

I know all that! Do You remember that I have already written several small articles on this subject? Since the early days of your developing of JForum 2.1.7 I have posted various small patches.

At the moment I use your official 2.1.7 release together with a SQLServer2005 DBMS.
It seems to function --- even the result-set-paging.
Till present only one more problem has appeared: The select of all articles owned by a certain forum-user probably contains one more SQL ... LIMIT statement, which has to translated to sqlserver-syntax. I am working on this ...

Rafael Steil wrote:Is the SQL Server db running 100%?

100% ? Hard to say! I will further observe this ...

[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

Meanwhile I have carried out further changes.

A summary of all changes is included in the following file:

(An adaptation of the files sqlserver_db_struct.sql and sqlserver_data_dump.sql will follow later ...)


[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

Awosome. I'll add them to the cvs.

Registered in Jira: http://www.jforum.net/jira/browse/JF-606

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Is 2.1.7 release support mssql?
[originally posted on jforum.net by VVD]

[Migrated From Jforum.net]

VVD wrote:Is 2.1.7 release support mssql?

Yes, take my changes/addons (see above) and it should work.

An adaptation of the files sqlserver_db_struct.sql and sqlserver_data_dump.sql will follow later ... Actually i didn't need them for the 2.1.7 update because we started already with a 2.1.6 release against mssqlserver ...

Watch this thread ...

[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

My current summary of all changes for SqlServer(2005)-support is included in the following zip-file:

(Note: I added the adaptation of the files sqlserver_db_struct.sql and sqlserver_data_dump.sql)


[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

Done.

http://www.jforum.net/jira/browse/JF-606

Rafael
[originally posted on jforum.net by Rafael Steil]