Sunday, May 8, 2011

Getting Community Assist database through Visual studio

Open visual studio
From the view menu select Server Explorer
In the server explorer window right click on the data sources icon and select new data source
in the window that gives you the options of which type of data source to choose, select sql server
In the following dialog box type ".\sqlexpress" or your computer name \ sqlexpress for the server and choose "Master" for the database
(If you have installed a full edition of sql server you can use "localhost" for the server name)


click OK
This will add a connection to your server explorer
Then go to the data menu and select "Transact sql editor -> new query connection
It will open a new query window
Click connect


Get the CommunityAssist database script and paste it into the query window



Go to the DATA menu option choose Transact SQL Editor -> execute sql
This will create the database
You will want to create a another new database connection to community assis

No comments:

Post a Comment