Raspberry PI as test box

  • bugmesh

    SSC Enthusiast

    Points: 185

    Woke up and sprained my brain this morning. That's the only reason I can think of as to why this popped into my head.

    Has anyone used a Raspberry for a test environment for SQL Server? What issues would nee to be addressed?

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    bugmesh (4/3/2014)


    Woke up and sprained my brain this morning. That's the only reason I can think of as to why this popped into my head.

    Has anyone used a Raspberry for a test environment for SQL Server? What issues would nee to be addressed?

    Unfortunately it will not work, no Windows version for ARM that supports SQL Server to my knowledge

    😎

  • john.next

    SSC Rookie

    Points: 39

    The Raspberry Pi 2 will support Windows 10[/url], so perhaps it could be done in the future.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714591

    There are ODBC drivers for Linux. Not sure they work on the Rasberry Pi (should test), but the new v13 in preview is supposed to support more OSes.

  • Eric M Russell

    SSC Guru

    Points: 124963

    Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user testing purposes. If what you want is an isolated sandbox, then consider running a VM like VirtualBox or VMware on your work / home PC.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714591

    Eric M Russell (2/23/2016)


    Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user testing purposes. If what you want is an isolated sandbox, then consider running a VM like VirtualBox or VMware on your work / home PC.

    This is if you need the Raspberry to be the host.

    As a test box, it could be a client, with queries or simulating load. In that case, it would be an interesting use, with multiple Raspberry PIs.

  • Eric M Russell

    SSC Guru

    Points: 124963

    Steve Jones - SSC Editor (2/23/2016)


    Eric M Russell (2/23/2016)


    Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user testing purposes. If what you want is an isolated sandbox, then consider running a VM like VirtualBox or VMware on your work / home PC.

    This is if you need the Raspberry to be the host.

    As a test box, it could be a client, with queries or simulating load. In that case, it would be an interesting use, with multiple Raspberry PIs.

    If we're talking about using Raspberry PI as a client, then there are a handful of options for Linux or Andoroid.

    Microsoft ODBC Driver for SQL Server on Linux

    https://msdn.microsoft.com/en-us/library/hh568451(v=sql.110).aspx

    ".. FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases .."

    http://www.freetds.org/

    ".. jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server .."

    http://jtds.sourceforge.net/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Learning DBA

    SSC Rookie

    Points: 25

    /sorry (removed posting)

    4 life

Viewing 8 posts - 1 through 8 (of 8 total)

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