Monday, March 12, 2012

How to create a new SQL2005 DB?

Hi folks,

i have VSTS installed and TFS beta refresh 3. all is working fine.

How can i use Visual Studio 2005 to create a new database on the remote server? i can connecto to it fine using the 'server explorer' tab .. but of course it only lists databases that currently exist. How can i create a new one?

lastly, i have no installed sql2005 express edition or whatever it is called LOCALLY on my machine. the reason i didn't do this is becuase i was hoping to use the enterprise sql 2005 server.

If your are using the SQLExpress version best thing to do is download and install the SQLExpress Management Studio CTP from microsoft. It basically gives you the same functionality that is in the full SQL2005 versions.

After running the studio and connecting to the database engine you can navigate to the databases node, right click, new, Database then begin configuring all your tables, constraints and security.

The management studio CTP can be had herehttp://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

|||

Ahh! so this Management Studio is the equivalent to the SQL CLIENT TOOLS for our sql server 2000's?

is there a Management Studio for sql2005? is it found on the sql2005 cd or do we download it?

|||The SQL Management Studio is installed by default in all versions of SQL2005, Eval, Std, Dev and Enterprise. it can be found in Start--All Programs--Microsoft SQL Server 2005--SQL Server Management Studio. The CTP version can be used to connect to any SQL2005 instance on the network. Just choose the Server/Instance from the drop down list in the Connect to Database engine dialogue or manually type the server/instance name.|||

ahh, interesting.

i installed Team Foundation Server beta refresh 3. Part of that is the SQL2005 install. I installed my SQL2005 version using the MS provided UNATTENDED INSTALL file. This file must have excluded the management studio! damn :(

that said, what about clients trying to manage a sql server, where the sqlserver is remote. Are there client tools on the SQL2005 CD?

No comments:

Post a Comment