Raspberry PI as test box

Question

Raspberry PI as test box

bugmesh

SSC Veteran

Points: 216
More actions
April 3, 2014 at 7:13 am

#285302

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?

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

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

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 More actions · Answer 2

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: 736212 More actions · Answer 3

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: 125561 More actions · Answer 4

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: 736212 More actions · Answer 5

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: 125561 More actions · Answer 6

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 More actions · Answer 7

Learning DBA

SSC Rookie

Points: 25

February 26, 2018 at 9:35 am

#1981119

/sorry (removed posting)

4 life