Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Exporting maps to files

contracer

Is there any way to export all NPM 9.5 maps from DB to local files ?

Find more posts tagged with

Accepted answers

All comments

bshopp

What are you trying to accomplish? Do you just want a backup for DR purposes?

contracer

Exactly. In NPM 9.1 version I made a .bat file to copy all maps to another folder before make any changes. But in NPM 9.5 maps are in the DB, and I don't know how create a DR.

redsupra101

i need to do this same thing after my upgrade to 9.5 this week, so looking forward to a response. right now the solution is backing up the whole db, but at 9+ gigs of db and 24/7 users online, its a bit of a hassle.

bshopp

Best method is to backup the MapStudioFiles table.

To backup data from a particular table use MS SQL Server Management Studio.

In this tool use “Export Data” task and choose another DB as data destination.

You can create new (empty) database. Then, during the export, you can choose only the “MapStudioFiles” table and you can use your new empty DB as destination.

To restore data use the “Import Data” task.

KMSigma.SWI

This looks to be an old thread, but I wrote an option that works for me.