Hi Sean,
if you find a simpler way that will work in the OTRS architecture, I'm
absolutely open.
OTRS defines database schemas and schema changes in XML, please see
scripts/database/otrs-schema.xml. From this, the DBObject creates the
SQL files for the different DB types with the help of our
Martin,
I think I may have misled myself but would like your confirmation.
I got the impression from browsing
https://github.com/OTRS/otrs/tree/rel-3_3/scripts/database.
Here, it appears that there are database scripts for different providers, one
of which was an MSSQL provider.
Hi Sean,
exactly. These files are generated from the XML (with
bin/otrs.xml2sql.pl) and will be overwritten whenever there are changes
to the XML and/or the drivers.
Regards, mg
Am 08.04.14 12:04, schrieb Sean Killeen:
Martin,
I think I may have misled myself but would like your
As we consider this further, in the meantime, is some sort of data dictionary
available? I've looked and found the diagram but it would be great to find a
description of some of those tables so that I can examine how to best go about
accomplishing the clustered indexes.—
Sean
E-mauled from my
Martin,
Regarding your closing of the bug report as a feature request, I'm not sure
it necessarily has to be that way.
It is only a small subset of T-SQL Commands that are not supported in SQL
Azure. The list: http://msdn.microsoft.com/library/azure/ee336250.aspx
The elements that are not
Hi,
I saw a requirement for having indexes on all tables for replication
before; also as a need for replication, but on a different database
than SQL Server.
For Sean it would be possible to add indexes of identity columns to
these tables (caveat: untested)
ALTER TABLE [yourTable] ADD MyID INT
@Mike, thanks for the additional interest!
I understand that some of these tables may have no need for primary keys at
all.
In this case, would it make the most sense to create just a clustered index
that included all columns (without adding a PK constraint?)
This would serve SQL server by
*Summary: *I'd like to alter some DB scripts to add clustered indexes so
they work better for MSSQL (and work at all for SQL Azure). How should I go
about this?
Hi all,
New to contributing to OTRS and to the dev mailing list so please forgive
me if I stumble around a bit.
*Background / Issue*