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
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?
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).