Hosting FAQ
I want to create a C1 site which uses SQL Server. How do I do this?
Answer:
To run a website that uses a Microsoft SQL Server database as its data store, use the Composite.Tools.SqlServerDataProvider package.
In short:
- Create an XML-based website.
- Prepare an empty database on Microsoft SQL Server and make note of its connection string, e.g.:
"Data Source=[server name];Database=[database name];Integrated Security=True"
or "Data Source=[server name];Database=[database name];User Id=[username];Password=[password]" - From the System perspective, install the Composite.Tools.SqlServerDataProvider package.
- In the System perspective, use SQL Server Data Provider to migrate your data store from XML to SQL.
For more information, please see Composite.Tools.SqlServerDataProvider.