SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Wizard mcsolas's Avatar
    Join Date
    Jul 2004
    Location
    Hermosa Costa Rica
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Getting started with SQL server

    I have been working on a database for the past 6 months in access, just doing the design and basics. Now that I am loading up the data in there, its time for me to learn a few new tricks. This one is going to be in SQL , which I dont know much about yet.

    I was just wondering if I could get some advice on preferred apps to manage the data. The hosting company I have supports this so I really just need to convert it over from access and start using some new tools.

  2. #2
    SitePoint Enthusiast
    Join Date
    Nov 2004
    Location
    Abilene, TX
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Exactly which SQL Server are you referring to (mySQL, SQLLite, PostgreSQL, MSSQL, etc)?
    Reg

    "I don't care how many beers you've had...
    Get your chickens out of my lawn!"

  3. #3
    SitePoint Wizard mcsolas's Avatar
    Join Date
    Jul 2004
    Location
    Hermosa Costa Rica
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Microsofts SQL Server

  4. #4
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi
    start your db in MS Access, go to tools >> Database utility >> Upsizing wizard.

    Guess you can take it from there, 'cos its simple and straightforward.

    Or from MS SQL Server, start, DTS, import/export wizard, and from the data source drop down dialog box, choose MS Access, and the wizard will take you through the proceedure.

    rgds
    Afrika

  5. #5
    SitePoint Wizard mcsolas's Avatar
    Join Date
    Jul 2004
    Location
    Hermosa Costa Rica
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So are you saying that I can manage it all through Access? If so that really answers my question. I wasn't sure what apps I needed to get started.

  6. #6
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So are you saying that I can manage it all through Access?

    I didnt say you can manage through access, i gave 2options to upsize your db, to SQL server.

    then you can start using SQL server.

    You choose your db, depending on scalability


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
  •