Chapter 12. Installing SQL Server Databases
In this chapter, we will cover the following topics:
- Installing a SQL Server instance with a bootstrapper
- Adding a database to a SQL Server instance
- Creating a table within a SQL Server database
- Inserting data into a database table
- Creating an ODBC data source for a SQL Server instance
Introduction
Data is vital to most applications. So, it's likely that you'll want to set up a database at installation time to store data. The WiX Toolset gives us a mechanism to add a new instance of SQL Server and then add databases, table definitions, and data to it. In this chapter, we'll cover these common tasks and also touch upon how to set up an ODBC data source, which gives a standardized way for applications of various ...
Get WiX Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
