Knowledgebase: Databases
How do I manage a MS SQL database?
Posted by Joe Rebis (Import) on 16 September 2006 09:38 PM

 

Managing a MS SQL Database:

 

A MS SQL database physically resides on a separate server. You will not be able to download it by FTP. Instead you will edit the database live in real-time.

 

To do this, you will need to connect to the database using a database management tool. For MS SQL you have a few choices:

  1. MS Enterprise Manager (MS SQL 2000 Only): This is available as part of the MS SQL Server 2000 trial edition download available from Microsoft's website. When installing the software - install only the "Client Tools". It will not expire and it fully-functional.
  2. MS SQL Server Management Studio (MS SQL 2000-2005)**: You can download and install this for free from Microsoft's website. It can be used to access the MS SQL 2005 server and manage databases. [Download SQL Server Management Studio (SSMS)]
  3. MS SQL Manage Lite: This is software is free (currently) but has some limits to it's use. A Paid more robust version is also available. You can download it directly form their website. It has a very nice interface and it worth the full version purchase if you plan to use your database often. [SEE: EMS SQL Manager downloads]
  4. SQL Server Management Studio (SSMS): 
    This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2016), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database.
    There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly.
    Additionally, one SSMS 16.x release or SSMS 2016 can be installed side by side with previous versions of SSMS 2014 and earlier.
    [Download SQL Server Management Studio (SSMS)]

**NOTE: This edition does not allow you to use SSIS (the new name for DTS). If you need to use that functionality, download and install the MS SQL Server 2005 Developer version. It may be a paid product but well worth the investment.

 

Connection Information:

IP Address: Please search the KB for "Important IP Addresses".

Port: 1433

Database: The database name you created.

Username: The database username you created.

Password: The database password you created.

 

Complete details on how to manage your database from a programming standpoint is beyond the scope of this document. More information as well as tutorials can be found on Microsoft's website.

 

SEE ALSO

 

 

(869 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright © 2015 EPhost, Inc. All rights reserved.