September 19, 2013 at 7:53 am
Hi,
I am new to SQL Server but am looking to make the switch from Oracle 11g. Is it possible to install SQL Server 2008 + SSMS onto a Windows XP machine and then upgrade to Windows 7 after?
Also, how much memory does SQL Server generally require for a small scale Database?
Thanks,
J
September 19, 2013 at 8:04 am
Speaking as someone who has upgraded a laptop from XP to 7 (both Pro versions, though), yes, it is possible.
As far as memory goes... That depends on the edition of SQL Server you have, not on the database. Additional memory after that depends on what you're going to be doing with the database afterwards, but I would recommend installing as much RAM as you can ... just because. @=)
September 19, 2013 at 8:20 am
Perfect! Thanks for your reply.
September 19, 2013 at 8:37 am
Glad I could help.
September 19, 2013 at 11:18 am
The RAM needed depends on the size of the database and the number of users/transaction load. In my experience, if the size if the "small scale" database is smaller than the amount of RAM you can set the SQL maximum RAM setting to and you have a handful or less number users (less than 20), then the performance can be excellent as SQL could potentially load the entire database into RAM and not have to go to the disk for most queries.
Is the Windows 7 upgrade scheduled at an indefinite time in the future? I'd really prefer to install SQL after an OS upgrade instead of upgrading an OS underneath SQL. If XP is 32 bit you also upgdrade to Win7 64-bit and install the 64-bit version of SQL.
September 19, 2013 at 12:31 pm
The upgrade is due in 3 months. I just wanted to get ahead of schedule.
September 20, 2013 at 5:35 am
Make sure you have a good recovery plan (and lots of backups) in case the upgrade goes wrong. My laptop wasn't an issue because it was my personal sandbox and nothing depended on it.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply