You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
# Save and load R objects from SQL Server using ODBC
14
+
# Use ODBC to save and load R objects in SQL Server Machine Learning Services
15
15
[!INCLUDE [SQL Server 2016 and later](../../includes/applies-to-version/sqlserver2016.md)]
16
16
17
-
SQL Server R Services can store serialized R objects in a table and then load the object from the table as needed, without you having to re-run the R code or retrain the model. This ability to save R objects in a database is critical for scenarios such as training and saving a model, and then using it later for scoring or analysis.
17
+
Learn how to use the **RevoScaleR** package to store serialized R objects in a table and then load the object from the table as needed with [SQL Server Machine Learning Services](../sql-server-machine-learning-services.md). This can be used when training and saving a model, and then use it later for scoring or analysis.
18
18
19
-
To improve performance of this critical step, the **RevoScaleR** package now includes new serialization and deserialization functions that greatly improve performance, and store the object more compactly. This article describes these functions and how to use them.
19
+
To improve performance, the **RevoScaleR** package now includes new serialization and deserialization functions that improve performance and store the object more compactly.
20
20
21
-
## Overview
21
+
## RevoScaleR package
22
22
23
23
The **RevoScaleR** package now includes new functions that make it easier to save R objects to SQL Server and then read the objects from the SQL Server table. In general, each function call uses a simple key value store, in which the key is the name of the object, and the value associated with the key is the varbinary R object to be moved in or out of a table.
24
24
@@ -40,7 +40,7 @@ By default, any object that you call from R to move to SQL Server is serialized
40
40
41
41
-`rxListKeys` lists as key-value pairs all the available objects. This helps you determine the names and versions of the R objects.
42
42
43
-
For detailed help on the syntax of each function, use R help. Details are also available in the [ScaleR reference](/r-server/r-reference/revoscaler/revoscaler).
43
+
For detailed help on the syntax of each function, use R help. Details are also available in the [ScaleR reference](/machine-learning-server/r-reference/revoscaler/revoscaler).
44
44
45
45
## How to store R objects in SQL Server using ODBC
46
46
@@ -109,4 +109,8 @@ This procedure demonstrates how you can use the new functions to load a model fr
109
109
110
110
```R
111
111
infertLogit2<- rxReadObject(ds, "logit.model")
112
-
```
112
+
```
113
+
114
+
## Next steps
115
+
116
+
+[What is SQL Server Machine Learning Services?](../sql-server-machine-learning-services.md)
0 commit comments