This article will cover the correct steps to pull your Vast Data and import that data into Tekmetric successfully. In this article we will review how to:
- Stop SQL Services and Export your Vast Data
- Upload your Vast Data into Tekmetric
- Restart your SQL Services
Exporting Vast Data
1. From your Windows desktop, to access the SQL files used by VAST, you'll want to right-click on the Windows icon, and select Computer Management.
2. From Computer Management, you want to expand the Services and Applications option and select Services.
3. Scroll down until you see the service called SQL Server. You'll see there's several SQL server items. Select the first one that just says SQL Server (you don't want the agent or the browser) and you should see that it's running.
Note: You will want to make sure you're out of VAST before you start this process, so get out of VAST on all computers, then go in to Services and stop the SQL server.
4. Right-click on that service and stop it. That will allow you to have access to the SQL files.
5. Once you've stopped the SQL server, right click on the Windows icon and go to File Explorer.
6. The SQL files are stored on the C: Drive in a folder called \DBVAST. You'll should see the .mdf file.
7. Right-click and COPY the .mdf file
8. Create a folder called "TEMP" in the C:Drive
9. Paste the .mdf file into the "TEMP" folder you just created
10. Highlight the file in the "TEMP" folder. You will then Right-click > select "Send to" > select "Compressed" to compress the file
Upload into Tekmetric's Data Migration Tool
1. Navigate to Tekmetric and go to shop settings > INTEGRATIONS tab and go to the Data Migration Upload Tool Box
2. Click Upload, and in the window that pops up, click UPLOAD FILE
3. Search for the Compressed Zip file and upload it
Crucial: Turn Back on SQL Server
1. Once you're done, you’ll need to restart the SQL server service.
2. Right-click on the Windows icon and select Computer Management.
3. Select Services and Applications, expand and click on services.
4. Scroll down to SQL Server, right-click and start the service. That will allow you to continue to run VAST.