Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Mssql

Hello!

I´ve managed to port the full database to mssql.

Simply use Xampp and install osticket. Then create an empty database named ost in MSSQL (I used MSSQL2008)

Use the converter from http://www.convert-in.com/ (trial version is enough) ,
to connect between mysql and mssql and convert directly between the servers.

I´m currently in the process of changing connectors in the code.

I´ll post the results after testing.

Comments

  • Mssql script

    Ill post the sqlscript to any who want to give a look. Maybe the admins can include it in version.
    ost_mssql.zip
    11K
  • can anyone please help install osticket with MSSQL ?
  • While we plan on supporting multiple databases - this is absolutely not how we plan on doing it. Some hardcoded queries are MYSQL specific and will be a nightmare to keep track of multiple versions of the software and databases.

    The plan is to use ORM model to make the code base database agnostic. We've already started moving in this direction and hope to have the whole code base converted early next year.
This discussion has been closed.