create database in sql server 2005 express edition without Browser
I have an SQL server Express edition Instance and I nee开发者_如何学Pythond to create a database on it but I don't have the Sql Browser how can I do it other wise
You can connect using "Server Explorer" in Visual studio (menu View, Server Explorer).
This window allows you to connect to an existing database (Sql2000, 2005, 2008, access).
Once you are able to connect you can:
- Use CREATE DATABASE commands
- (Best) Create a visual studio database project and use deployed script to create Database.
If you want you can setup database project to automatically deploy to a DB.
hope these links can help you:
http://arcanecode.com/2007/01/26/create-a-table-in-sql-server-compact-edition-with-c/
http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx
精彩评论