开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜