Hi
my organisation does not support MySQL and hence we are forced to install on MS SQL 2008. Please could you share your experiences if you are using testlink 1.9.3 with MS SQL. Could you also list out the issues faced and resolutions. Thanks.
Is MS SQL 2008 supported by 1.9.3?
Moderators: Amaradana, TurboPT, TL Developers
Re: Is MS SQL 2008 supported by 1.9.3?
we do not test intensivelly on MSSQL (we do not have developers on team that use day by day this DB).
Have done sometimes ago light tests (i.e. not 100% feature) on MSSQL 2008 EXPRESS.
There are some issues reported on Mantis and some topics forum regarding some blocking issues due to some FIELD we have missed on install script, but people has indicated what was.
When some FIELD is missing or wrong PHPADODB driver for MSSQL has an extrange behaivour: operation takes YEARS to end without a clear warning. In this kind of situation SQL profiler is needed to understand if query is wrong (really an annoyeance).
If you so searchs here and on mantis, you will get these users names => may be you will be able to contact them.
An alternative is
Install on MySQL, check everything work ok then migrate DB to MSSQL with some migration tool (think will not difficult to find such kind of
tools on Internet).
Please share with us your findings in order to help us to improve support on this DB.
Have done sometimes ago light tests (i.e. not 100% feature) on MSSQL 2008 EXPRESS.
There are some issues reported on Mantis and some topics forum regarding some blocking issues due to some FIELD we have missed on install script, but people has indicated what was.
When some FIELD is missing or wrong PHPADODB driver for MSSQL has an extrange behaivour: operation takes YEARS to end without a clear warning. In this kind of situation SQL profiler is needed to understand if query is wrong (really an annoyeance).
If you so searchs here and on mantis, you will get these users names => may be you will be able to contact them.
An alternative is
Install on MySQL, check everything work ok then migrate DB to MSSQL with some migration tool (think will not difficult to find such kind of
tools on Internet).
Please share with us your findings in order to help us to improve support on this DB.