Today I needed to import my SQL Server schema into a SQL Server Express instance on a different machine. I only have Visual Studio on this machine and no SQL Server Management Studio installed, so it took me a bit to figure out how to import the schema, so here it goes.

1. Add the SQL Server Express instance to the Server Explorer. It’s located at “.\SQLEXPRESS”.
2. Open the T-SQL database schema. It will say “not connected” at the end of the tab caption.
3. In the “Data” menu you will have to “Connect” and then Validate and Execute SQL.
4. Done.

I bet the same can be done with SQL Server Management Studio Express but I have yet to install it.