locked
Create database in SQL (database engine only download) RRS feed

  • Question

  •      Just downloaded SQL database engine only (2008), and I wanted to started creating simple databases and transferring, deployine etc... I thought I would not have to download .net, visual, or any of the develop family suites to build and integrate tables and simple databases. I'm on Windows 7 home premium machine just testing for roll out to 2008 R2 full. Please assist on how to created simple database in SQL database 2008 engine only download. I have had chat sessions, searched online resources, and other avenues. Can you direct in the right area, or online help to start creating.

    Coleasice

     

    Friday, April 2, 2010 7:19 PM

Answers

  • I think you need to install SSMS (SQL Server Management Studio). I don't imagine how can you do any tasks without it.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by David Dye Friday, April 2, 2010 8:03 PM
    • Marked as answer by LekssEditor Saturday, April 3, 2010 6:22 AM
    Friday, April 2, 2010 7:26 PM
  • You can use sqlcmd, the command line utility to do this, but I gotta agree with Naom and SSMS is the way to go, althouogh I still think using the command line is COOL!

    You can download SQL Server Management Studio Express here:

    http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

    This will lprovide you the graphical tools to get started.  As far as working with a database you can go to CodePlex to download the sample databaseas:

    http://msftdbprodsamples.codeplex.com/

    If you are looking at challenging yourself and using sqlcmd then here is the online documentation, but SSS is definitely easier:

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    If you are looking for hands on exercises in SQL 2008/2005 etc. then you can find virtual labs with step by step instructions for specific exercises and virtual servers here, SQL labs can be found under Server Products

    http://technet.microsoft.com/en-us/virtuallabs/default.aspx

     

    Hope this helps


    David Dye
    • Proposed as answer by Naomi N Friday, April 2, 2010 8:31 PM
    • Marked as answer by LekssEditor Saturday, April 3, 2010 6:22 AM
    Friday, April 2, 2010 8:03 PM
  •       Wanted to thank all of you guys for all of your help. SSMS is the only way to go when object oriented based, or queries are at hand. This console is what I needed. I also have to say that I enjoy the CMD features as well. Until the next problem occurs.

    Have a geat week-end!!!!!

    Coleasicec

    • Marked as answer by Coleasice Tuesday, May 4, 2010 5:55 PM
    Tuesday, May 4, 2010 5:55 PM

All replies

  • I think you need to install SSMS (SQL Server Management Studio). I don't imagine how can you do any tasks without it.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by David Dye Friday, April 2, 2010 8:03 PM
    • Marked as answer by LekssEditor Saturday, April 3, 2010 6:22 AM
    Friday, April 2, 2010 7:26 PM
  •      Just downloaded SQL database engine only (2008), and I wanted to started creating simple databases and transferring, deployine etc... I thought I would not have to download .net, visual, or any of the develop family suites to build and integrate tables and simple databases. I'm on Windows 7 home premium machine just testing for roll out to 2008 R2 full. Please assist on how to created simple database in SQL database 2008 engine only download. I have had chat sessions, searched online resources, and other avenues. Can you direct in the right area, or online help to start creating.

    Coleasice

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------Vote As Helpful

    0

    Vote As Helpful

    I think you need to install SSMS (SQL Server Management Studio). I don't imagine how can you do any tasks without it.

    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------Vote As Helpful
         
     Just downloaded SSMS (SQL Server Management Studio). Coud you direct me from here. I can not seem to get started with building a simple database with the 2008. I will keep trying and searching. Thanks for all of your help. All resources and help are much appreciated.
    Coleasice
    Friday, April 2, 2010 8:00 PM
  • Once you open SSMS, in the object explorer right click on the databases and create new, then just follow the prompts. Alternatively you can go this in T-SQL code using CREATE DATABASE syntax (open new query window first).
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Friday, April 2, 2010 8:03 PM
  • You can use sqlcmd, the command line utility to do this, but I gotta agree with Naom and SSMS is the way to go, althouogh I still think using the command line is COOL!

    You can download SQL Server Management Studio Express here:

    http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

    This will lprovide you the graphical tools to get started.  As far as working with a database you can go to CodePlex to download the sample databaseas:

    http://msftdbprodsamples.codeplex.com/

    If you are looking at challenging yourself and using sqlcmd then here is the online documentation, but SSS is definitely easier:

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    If you are looking for hands on exercises in SQL 2008/2005 etc. then you can find virtual labs with step by step instructions for specific exercises and virtual servers here, SQL labs can be found under Server Products

    http://technet.microsoft.com/en-us/virtuallabs/default.aspx

     

    Hope this helps


    David Dye
    • Proposed as answer by Naomi N Friday, April 2, 2010 8:31 PM
    • Marked as answer by LekssEditor Saturday, April 3, 2010 6:22 AM
    Friday, April 2, 2010 8:03 PM
  • You can use sqlcmd, the command line utility to do this, but I gotta agree with Naom and SSMS is the way to go, althouogh I still think using the command line is COOL!

    You can download SQL Server Management Studio Express here:

    http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

    This will lprovide you the graphical tools to get started.  As far as working with a database you can go to CodePlex to download the sample databaseas:

    http://msftdbprodsamples.codeplex.com/

    If you are looking at challenging yourself and using sqlcmd then here is the online documentation, but SSS is definitely easier:

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    If you are looking for hands on exercises in SQL 2008/2005 etc. then you can find virtual labs with step by step instructions for specific exercises and virtual servers here, SQL labs can be found under Server Products

    http://technet.microsoft.com/en-us/virtuallabs/default.aspx

     Hope this helps

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------

         Yes it does David,

    Hope you, Naomi have a great week-end.

    Coleasice


    David Dye
    Friday, April 2, 2010 8:23 PM
  •       Wanted to thank all of you guys for all of your help. SSMS is the only way to go when object oriented based, or queries are at hand. This console is what I needed. I also have to say that I enjoy the CMD features as well. Until the next problem occurs.

    Have a geat week-end!!!!!

    Coleasicec

    • Marked as answer by Coleasice Tuesday, May 4, 2010 5:55 PM
    Tuesday, May 4, 2010 5:55 PM