Creating a database instance in C#

Question

Is it possible to create a sql database instance with C# code. I have no problem adding a database to an existing SQL instance, for example WONEA\SQLEXPRESS but for creating another SQL instance such as WONEA\SQLEXPRESSTEST I'm a little stumped. Help!

Answer 1

Creating new instances requires running the installer for SQL server, so I would imagine the answer is "No." (Would be interested to hear otherwise though!)

Answer 2

The short answer is you can't do this using C# code.

SQL server instances are essentially installations of SQL server - in order to create a new SQL server instance you need to run the SQL Server installer, and ask it to install one (which you can technically do from C# code, but I gather thats not the answer you were looking for).