在IIS上使用SQL Server安装TYPO3 8.7.7 [英] Install TYPO3 8.7.7 with SQL Server on IIS

问题描述

我试图在我的Web服务器(IIS)上安装TYPO3(8.7.7)，我想使用我的SQL Server代替MySQL.

I tried to install TYPO3 (8.7.7) on my Webserver (IIS) and I'd like to use my SQL Server instead of MySQL.

(在typo3.org和其他网站上)我找到了很多如何进行此操作的说明，但是这些说明都不适合我.

I found lots of instructions how to make this (on typo3.org and other websites) but none of these worked for me.

我发现，在开始安装之前必须安装两个扩展(ADOdb& DBAL).可能是我的错.

I found out, that I must install two extensions before I start the installation (ADOdb & DBAL). Probably there is my fault.

有人可以逐步说明在安装TYPO3之前如何安装这些扩展吗?

Can anybody explain step by step how to install these extensions before the TYPO3 installation?

推荐答案

我正在使用以下配置在本地Windows计算机上的SQL Server上成功运行TYPO3:

I'm using the following configuration to successfully run TYPO3 on SQL Server on my local windows machine:

'DB' => [
    'Connections' => [
        'Default' => [
            'charset' => 'utf-8',
            'dbname' => 't3',
            'driver' => 'sqlsrv',
            'host' => 'localhost',
            'password' => 'yourPassword',
            'port' => 1433,
            'user' => 'sa',
        ],
    ],
],

使用安装程序进行安装有点复杂，因为它尚无法单击".您可以做的就是调用安装脚本，当它要求您配置数据库连接时，您转到文件系统，并在LocalConfiguration.php文件中手动添加上面的config部分(当然，带有连接参数).

It's a bit complicated to set up with the installer as it is not yet "clickable". What you can do is call the install script and when it's asking you to configure the database connection you go to your file system and manually add the config section above (with your connection params of course) in the LocalConfiguration.php file.

然后重新加载安装程序-现在安装程序应该可以识别已配置的数据库连接，并转到最后一步，您可以在其中导入/创建基本表和数据.

Then reload the installer - which should now recognize the configured database connection and let you go to the last step where you can import / create the base tables and data.

注意:目前，我知道在TYPO3 8.7中SQL Server仍然存在问题的两个较大区域-工作区和数据库比较.最后一个意味着在SQL Server表中已有数据之后，您将无法通过TYPO3数据库比较工具更改它们-如果需要，您必须手动更改表.

Note: At the moment I know of two bigger areas where SQL Server is still a problem with TYPO3 8.7 - that's workspaces and database compare. The last one means that after you have existing data in your SQL Server tables won't let you alter them via the TYPO3 database compare tool - you have to change tables manually if you need to.

找到表的要点，在 https://gist.github.com/psychomieze/9570ea1f578aee7a1fbb68c3240a21c8

这篇关于在IIS上使用SQL Server安装TYPO3 8.7.7的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！