Post reply

Windows XP Conversion

  • September 19, 2013 at 7:53 am

    #395520

    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

    #1651523

    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. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 19, 2013 at 8:20 am

    #1651536

    Perfect! Thanks for your reply.

  • September 19, 2013 at 8:37 am

    #1651547

    Glad I could help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 19, 2013 at 11:18 am

    #1651602

    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

    #1651638

    The upgrade is due in 3 months. I just wanted to get ahead of schedule.

  • September 20, 2013 at 5:35 am

    #1651861

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy