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.
- Add the SQL Server Express instance to the Server Explorer. It’s located at “.\SQLEXPRESS”.
- Open the T-SQL database schema. It will say “not connected” at the end of the tab caption.
- In the “Data” menu you will have to “Connect” and then Validate and Execute SQL.
I bet the same can be done with SQL Server Management Studio Express but I have yet to install it.