SitePoint Sponsor

User Tag List

Results 1 to 8 of 8

Thread: SQL Server...

Hybrid View

  1. #1
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server...

    May someone please explain to me what I can do with SQL server...and some BASIC information about it...

    *Is starting to learn MS SQL Server Develop Edition*

    and needs to learn it FAST!

    Maybe I can do it without a book but anywho some basic info to start off with would be amazing ...
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  2. #2
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Short answer from Microsoft:
    Microsoft SQL Server is a relational database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. SQL Server 2000, the latest version, includes support for XML and HTTP, performance and availability features to partition load and ensure uptime and advanced management and tuning functionality to automate routine tasks and lower total cost of ownership.
    Basically, it's a full-featured database server comparble to IBM DB2 or Oracle.

    There are several articles and numerous posts here at Site Point that touch on the subject. You might also want to try www.4guysfromrolla.com or www.sqlteam.com.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  3. #3
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ok...

    Let me explain my prob...

    I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.

    #1 Will it copy and make the database exactly the same *same fields, same records etc.*

    #2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?

    Thanks
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  4. #4
    SitePoint Zealot
    Join Date
    Aug 2001
    Location
    North Carolina
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ok...

    Originally posted by davedibiase
    Let me explain my prob...

    I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.
    M$ has an upsizing to SQL script/wizard

    #1 Will it copy and make the database exactly the same *same fields, same records etc.*
    For the most part, yes, but it will still require some grooming. The field types are different and have different properties.

    #2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?
    Um, not exactly. Well, maybe yes, but I don't think you'd want to do it that way. For this, I'd recommend a book... There probably is a command similar to mysql's dump... but don't quote me.

    Thanks
    Andrew Thompson
    VPHost.com, part of the Untapped Resources Network.

  5. #5
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ok...

    Originally posted by davedibiase
    Let me explain my prob...

    I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.

    #1 Will it copy and make the database exactly the same *same fields, same records etc.*

    #2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?

    Thanks
    Hi,

    #1 SQL Server 2000 has a pretty sweet import feature (as does 7), you will however have to change some data types to suit your needs.

    #2. Yes it does, You cannot use this file as a stand alone file but you can unattach the MDB File and log file to take then accross to another server.

    I would suggest you get a book, there are so many things SQL Server can do and make your life soooo much easier, like Stored Procedures, Triggers, index's, replication etc.

    Hope this helps
    .NET Code Monkey

  6. #6
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Also, SQL doesnt' save things in a file such as access. it SERVES the data.

    Just putting in a little detail.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  7. #7
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ...

    thanks
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  8. #8
    SitePoint Addict kevin_tremblay's Avatar
    Join Date
    Jul 2001
    Location
    Boston Area (North shore)
    Posts
    233
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL servers import feature works great, I move stuff from Access to SQL all the time.

    Yes the data is stored in a folder called data under the SQL folder unless you located the data files to some other location other than the default.
    Kevin Tremblay-- Sys Admin
    work: kevin_tremblay@hsgmed.com
    "The object of the journey is not to arrive."


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •