{\rtf1\ansi\deff0\nouicompat{\fonttbl{\f0\fnil\fcharset0 Calibri;}}
{\colortbl ;\red0\green0\blue255;\red255\green255\blue0;\red0\green0\blue0;\red51\green51\blue51;}
{\*\generator Riched20 10.0.14393}\viewkind4\uc1 
\pard\sa200\sl276\slmult1\f0\fs22\lang9 VITGLOBAL.COM\par
ERUIDO CLOUD SETUP STEPS\par
REQUIREMENTS:\par
You need to have a dBAMonitor instance running against a local SQL server instance.\par
Since you are probable using SQL Server express, wich dont provide an Agent for scheduled tasks, we wrote some scripts to automate data deliveries to the cloud.\par
Yuo need to have Internet Access for both setup and cloud operations routines.\par
If you can not set it up by yourself, please ask for a setup ticket at {{\field{\*\fldinst{HYPERLINK www.eruido.org/support }}{\fldrslt{www.eruido.org/support\ul0\cf0}}}}\f0\fs22\par
Having that in place,\par
\b 1.- Create a linked server in your local SQL Server instance.\par
\b0 In order to send tyour local sql server data, to a remote sql server (cloud based) you will create a Linked server to communicate both local and remote (cloud) servers.\par
it can be done creating a new linked server at Server Objects leaf at SQL Server Managment Studio.\par
Please copy and paste the next code snipnet  into a new query window into SQl server Managment Studio, connected to your local sql server instance.\par
Replace \cf2\highlight3 <SQLSERVER NAME, PORT> \cf0\highlight0   for the provided server. Check this up in your Account Information.\par
Replace \cf2\highlight3 '<MY ERUIDO ID>',\cf0\highlight0   for eRuido Id provided. Check it out in Account Information.\par
\cf4\highlight3\par

\pard\li720\sa200\sl276\slmult1\cf2 USE [master]\par
GO\par
\par
/****** Object:  LinkedServer [<SQLSERVER NAME, PORT>]    Script Date: 27/02/2018 10:35:36 ******/\par
EXEC master.dbo.sp_addlinkedserver @server = N'<SQLSERVER NAME, PORT>', @srvproduct=N'SQL Server'\par
 /* For security reasons the linked server remote logins password is changed with ######## */\par
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'<SQLSERVER NAME, PORT>',@useself=N'False',@locallogin=NULL,@rmtuser=N'<MY ERUIDO ID>',@rmtpassword='<MY ERUIDO PASSWORD>'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'collation compatible', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'data access', @optvalue=N'true'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'dist', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'pub', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'rpc', @optvalue=N'true'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'rpc out', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'sub', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'connect timeout', @optvalue=N'0'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'collation name', @optvalue=null\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'lazy schema validation', @optvalue=N'false'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'query timeout', @optvalue=N'0'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'use remote collation', @optvalue=N'true'\par
GO\par
\par
EXEC master.dbo.sp_serveroption @server=N'<SQLSERVER NAME, PORT>', @optname=N'remote proc transaction promotion', @optvalue=N'true'\par
GO\par

\pard\sa200\sl276\slmult1\cf0\highlight0\par
Press execute button.\par
\par
2.- In the next files, replace the values  <SQL SERVER, PORT>,<MY ERUIDO ID>, \par

\pard\li720\sa200\sl276\slmult1 send2cloud.sql\par
load_local_data_buffer.sql\par
load_cloud_data_buffer.sql\par

\pard\sa200\sl276\slmult1\par
3.- In file Send2cloud.BAT\par
replace  <my pc/sql server instance name>  with your local PC name.\par
4.- Run Send2Cloud.bat\par
\par
\par
\par
\par
\par
}
