Run the following T-SQL command to enable the use of Full-Text Indexing in the database:ĮXECUTE Application.Configuration_ApplyFullTextIndexingĮnabling auditing in SQL Server requires server configuration.In SQL Server Management Studio, connect to the WideWorldImporters database and open a new query window.Therefore, a post-installation step is required. However, that feature is not installed by default with SQL Server - you need to select it during SQL Server setup (it is enabled by default in Azure SQL Database). The sample database can make use of Full-Text Indexing. If a lower pricing tier is desired, it is recommended to import into a new P1 database, and then change the pricing tier to the desired level. It will a few minutes to complete on a P1. Click Next and Finish to kick off deployment.Under Database Settings change the database name to WideWorldImporters and select the target edition and service objective to use.In the Import Settings select Import from local disk and select the bacpac of the sample database from your file system.Right-click on the Databases node, and select Import Data-Tier Application.Open SQL Server Management Studio and connect to your server in Azure.See this tutorial to create a database in minutes.In the process of create a database, you will create a server. (optional) If you do not yet have a SQL Server in Azure, navigate to the Azure portal and create a new SQL Database.To import a bacpac into a new SQL Database, you can use Management Studio. After it completes, you will have the database WideWorldImporters installed on your SQL Server instance. Note that it is best practice to place data and log files on different drives. If needed, change the target location for the data and log files, in the Files pane.In the dialog Select backup devices, click Add, navigate to the database backup in the filesystem of the server, and select the backup.Select Device and click on the button.Right-click on the Databases node, and select Restore Database.Open SQL Server Management Studio and connect to the target SQL Server instance.
To restore a backup to a SQL Server instance, you can use Management Studio. Note that recreating the sample will result in slight differences in the data, since there is a random factor in the data generation:
Source code to recreate the sample database is available from the following location. For the best results use the June 2016 release or later.ĭownload the sample WideWorldImporters database backup/bacpac that corresponds to your edition of SQL Server or Azure SQL Database.
For the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition. SQL Server 2016 (or higher) or Azure SQL Database.Wide World Importers OLTP database installation and configuration instructions. Applies to: SQL Server (all supported versions) Azure SQL Database
0 kommentar(er)
