Database Uploader

Can I use the STREAM Database Uploader to transfer a STREAM database from one STREAM SU system to another?

Can I use the STREAM Database Uploader to transfer a STREAM database from one STREAM SU system to another?

Category: 
Database Uploader and database transfer
Date Added: 
Thu, 08/03/2012 - 16:21

 

Yes, you can.  However, the STREAM Database Uploader will only restore databases from a database backup (.bak) file which contains a SINGLE data set.

This means that, when you create a backup on your first STREAM SU system, you need to make sure that you use the Option in SQL to override all previous backups in the set.

First, open SQL Server Management Studio Express on your first machine, and Right-Click on the Database Name to select the Backup task…

I receive an 'Unhandled Exception' error when trying to use the STREAM Database Uploader. What should I do?

I receive an 'Unhandled Exception' error when trying to use the STREAM Database Uploader. What should I do?

Category: 
errors and Database Uploader
Date Added: 
Tue, 08/03/2011 - 17:24

As explained in the STREAM Installation manual, if you are using the STREAM Database Uploader on Windows Vista or Windows 7, it is important to right-click on Uploader.exe and select the Run as administrator option.

Although you may have administrative rights under Windows, the Uploader will attempt to load a database into SQL Server.  Due to the User Access Control (UAC) feature of Vista and 7, this administrator status is NOT passed through to SQL Server.

Syndicate content