Which Database Engine Type Should Be Specified For Microsoft SQL Database In Laravel?
I am working on a web application using OctoberCMS which sits on Laravel 5.5.40 and is using a Microsoft SQL Database.
Database migrations are managed using the standard Blueprint objects which allow a database engine to be specified. Currently all the migrations are using InnoDB, which I believe is only supported by MySQL.
Does this mean that the engine type is being ignored? Also is it possible to specify different engine types for Microsoft SQL Database tables and what options are available?
The concept of "database engine" or "storage engine" is quite specific to MySQL; most database systems have a single back end which everything is built on. There are sometimes special types of database or table for specialist circumstances - e.g. adapters for importing data from other systems, or column-oriented stores for analysing large data sets - but they're rarely encountered.
For Microsoft SQL Server, there really isn't an equivalent option you need to specify. There may be other options you can set about how to configure the table for performance, but I would expect the ORM choose reasonable defaults and there isn't a single parameter with lots of tradeoffs like changing a MySQL engine.
- → How to make Laravel use my class instead of native PDO?
- → SQL: simple custom column in select doesn't work?
- → How to execute Stored Procedure from Laravel
- → Which database engine type should be specified for Microsoft SQL Database in Laravel?
- → How to troubleshoot PDOException?
- → laravel sql server stored procedure output
- → Issue with converting a date using Carbon
- → SQL microsoft query to Laravel 4.2
- → General error 20018 Cannot Continue the file execution because the session is in the Kill state
- → List names of all available MS SQL databases on server using python
- → Variable which replace DB of name in SSMS
- → Java: database connection. Where is my mistake?
- → How Can I use "Date" Datatype in sql server?