patternsqlMinor
Upgrade SQL Server 2016 R Service (in-database)
Viewed 0 times
sqldatabaseserviceserverupgrade2016
Problem
I am just wondering whether this is doable. I have installed R service (in-database) together with SQL Server 2016 (patched at SP1+ CU1).
I notice R service version is at 3.2.2, which you can run the following script to check
But I also installed Microsoft R client, and notice its R service engine is versioned at: 3.3.2.
So my question is "does SQL Server R service (in-database) now support R version 3.3.2 ?" if so, how can I upgrade it? if not, I guess I will wait until MS ships the update.
I read MSDN, and in it, it mentions using
I notice R service version is at 3.2.2, which you can run the following script to check
declare @v varchar(100);
exec sp_execute_external_script @language=N'R'
, @script = N'v <- toString(getRversion())'
, @params = N'@v varchar(100) output'
, @v = @v out;
print @v;
-- returns 3.2.2But I also installed Microsoft R client, and notice its R service engine is versioned at: 3.3.2.
So my question is "does SQL Server R service (in-database) now support R version 3.3.2 ?" if so, how can I upgrade it? if not, I guess I will wait until MS ships the update.
I read MSDN, and in it, it mentions using
sqlBindR.exe to do the update, but this tool is available only with Windows R server, which I did not install and I even doubt that if I installed it, whether it would update the in-database R service.Solution
I faced the very same problem (when trying to follow the steps described in Use sqlBindR.exe to Upgrade an Instance of R Services). I could not find any
A friend of mine pointed out to me, that I had to explicitly install "Microsoft R Server", not as part of the SQL Server install bits and pieces, but as a separate download.
All options about how you can download Microsoft R Server are described in a blog post at MSDN, Run Microsoft R Server for Windows by Heidi Steen.
Download and install was done in some minutes. SQLBindR took some more minutes.
Voilá: Now the following script is showing me, what I was looking for. :-)
SQLBindR.exe.A friend of mine pointed out to me, that I had to explicitly install "Microsoft R Server", not as part of the SQL Server install bits and pieces, but as a separate download.
All options about how you can download Microsoft R Server are described in a blog post at MSDN, Run Microsoft R Server for Windows by Heidi Steen.
Download and install was done in some minutes. SQLBindR took some more minutes.
Voilá: Now the following script is showing me, what I was looking for. :-)
declare @v varchar(100);
exec sp_execute_external_script @language=N'R'
, @script = N'v <- toString(getRversion())'
, @params = N'@v varchar(100) output'
, @v = @v out;
print @v;
-- returns 3.3.2Code Snippets
declare @v varchar(100);
exec sp_execute_external_script @language=N'R'
, @script = N'v <- toString(getRversion())'
, @params = N'@v varchar(100) output'
, @v = @v out;
print @v;
-- returns 3.3.2Context
StackExchange Database Administrators Q#162129, answer score: 5
Revisions (0)
No revisions yet.