Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Access to MS SQL 2005 question (newbie)

    I am a MS Access person hoping to learn SQL server. I work for a large school district and need to share databases for teacher input of test scores. Our IT department, who has ittle SQL knowledge, has set up MS SQL server 2005 for me and I have a few Access databases to migrate. I thought I could take an Access database and just run it through SQL Server Migration Assistant for Access (SSMA), but I have been told that we need a DBA to set up:

    Tempdb where/size
    Growth indicator
    Backup/Recovery
    Partition
    Max/Min memory
    Transaction logs
    Logs vs data placement
    Sizing very important effects performance

    before we migrate the database to SQL or the database may eventually stop working or have performance issues. Is this true, or can I just go through the SSMA process and fix problems as they arise?

    Robin

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are you talking about just installing SQL Server?

    Do you have a server, or are you doing a local install

    Are you going to use SQL Server Express?

    Why not just stick with Acccess???
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Are you talking about just installing SQL Server? SQL Server was just installed for me by our IT department.

    Do you have a server, or are you doing a local install?
    on a server

    Are you going to use SQL Server Express?
    No, MS SQL Server 2005

    Why not just stick with Acccess???
    problems with performance, problems with lockfiles hanging---requires server reboot which our IT department refuses to do, hoping our data warehouse vendor can access information from the SQL database (they're on the same server).

Posting Permissions

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