How do dump the data from servicenow DB to SQLServer ?

[john_thomas]

How do dump the data from service-now DB to SQLServer ?

[Liju John1 · Accepted solution]

Use SnowMirror | The Smart Data Replication Tool for ServiceNow

or ServiceNow ODBC Driver

[Andy26]

Hi Liju,

I am having the same requirement to take the DB back from service-now to local DB,kindly guide us how can we use ODBC connector to take entire dump in local db.

[Liju John1]

if you are dumping large scale data then go for use SnowMirror (over a million record)

[Deepak Ingale1]

There are different replicators available

1) eg, SnowMirror, Perspectium etc.

2) You can use export set to export data in EXCEL spread sheets and then can use as source for SQL

3) You can use JDBCProbe method to connect to SQL server and programatically dump the data to SQL server as well.