Creating the Data Repository
In the first article we took a look at the issues that required investigation prior to upsizing your existing database solution to Microsoft’s premium database, SQL Server 2000.
Within this article we will take a look at installing SQL Server 2000 locally, creating a database andatable in preparation to working with the data within Dreamweaver. We look at the three most common tools that you, as a developer, will be using. Then we look at creating a database within SQL Server, and the differences between Access and SQL Server in this area. We take a look at a database and its associated transaction log, discuss how to set the file sizes to allow for normal growth, and finally we create a table ready for use to use within our Dreamweaver application.
| Beginner | |
| Product: | Visual Studio.NET, Web Matrix, CSharp Editor, Dreamweaver MX, Borland C# |
| Database: | MS SQL Server |
| C#, VB.NET, J# | |
| Number Of Pages: | 8 |
Table of Content:
- Introduction
- SQL Server 2000 - Evaluation
- Local Install
- Enterprise Manager
- Query Analyzer
- Service Manager
- Creating a database
- A database in two parts
- Physical Creation
- Creating a table
- Summary
Robin Dewson
Robin is a SQL Server and Visual Basic consultant currently assigned to Lehman Brothers in London, England.
He enjoys Laurel and Hardy movies, and Rugby Football. He listens to 6Music from the BBC a great deal (see cool links) and can be found from a link on his home page.
