Solved

Create database on local machine

Posted on 2007-11-20
6
4,827 Views
Last Modified: 2012-06-27
I'm learning how to use MSSQL, I have SQL Enterprise Manager installed on my machine at work. I was also given access to the databases so I could start creating reports using Crystal Reports. (I have experience using MySQL and I just started this new job). What steps do I need to take to create a database on my local machine that I can use to practice? I'm going to be creating stored procedures that will run be the background of the report, and I would like to get some practice. Thanks!
0
Comment
Question by:horalia
  • 2
  • 2
  • 2
6 Comments
 
LVL 5

Expert Comment

by:mfsamuel
ID: 20322044
Microsoft SQL Server 2005 Express Edition can be found here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

It will have almost everything you need to begin working with SQL Server.  This appears in the SQL Server 2008 zone, but is your company using 2008 for their production data already?

For your Crystal development SQL Server 2005 Express Edition should do all you need.

-Marc
0
 

Author Comment

by:horalia
ID: 20322075
The Enterprise Manager and the SQL Query analyzer are both 8.0. I can see the databases that each server has, but I would like to create one on my desktop. Can my local machine run as a server too?
0
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20322567
version 8 ? That means that you are running SQL 2000, not SQL 2008 ...

Anyway, yes your local machine can act as a SQL server as well, just install the SQL Server 2005 Express on your own machine. It's free and there is a SQL 2005 client as well (SQL Server Management Studio). Here is the home page for the SQL 2005 Express:
http://www.microsoft.com/sql/editions/express/default.mspx

You should be able to find the download links here.

Hope this helps ...
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:horalia
ID: 20322738
Exactly what I need. Thanks!
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20322773
Glad I could be of any help and thanks for the grade !
0
 
LVL 5

Expert Comment

by:mfsamuel
ID: 20323050
isn't that the same link I provided?
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now