Moving Reports from one SQL server to another.

Here are the steps I used to move SQL Reporting Services reports from one server to another:

Create New Data Source:

• Go to the folder where your current report exists.
• Click Show Details located in the menu bar on the right.
• Open the Data Source on the old server by clicking the Edit icon next to the Data Source
• Open a Second Internet Browser window and go to your new SQL server with Reporting Services.
• Create a Folder structure that mirrors the Folder structure on the older SQL server.
• On the new SQL server, drill down to the same folder as the one you have open on the old server.
• Click New Data Source on the menu bar.
• Copy and Paste the information fields from the old server Data Source page to the new server. Click OK when you are done.

Copy the Reports:

• Go to the folder where your current report exists.
• Click Show Details located in the menu bar on the right.
• Click on the Edit icon next to the report you wish to copy.
• Under Report Definition Click Edit.
• A File Download screen will appear. Save the file to a temporary folder.
• On the new SQL server, drill down to the same folder as the one you have open on the old server.
• Click Upload in the menu bar.
• Click Browse and go to the file you saved in the previous step.
• Click OK to upload the report file.
• The report should now show up in your list.

Re-linking Report to Data Source on New SQL Server

• Before the report will work, it must be re-linked to the new data source on the new SQL server.
• Click the Edit icon next to the new report.
• Click Data Sources on the menu on the left of the screen.
• Click the Browse button and browse to the Data Source you created earlier. If you are uncertain as to which Data Source to use, go back to the old SQL server and look at the old reports settings.
• Click OK, test by opening the report.

Embedding Video on a SharePoint Page

In an effort to provide additional training resources for our staff we have begun creating short videos demonstrating how to use a particular software application. Our company uses SharePoint as our Intranet. We wanted the ablility to embed these videos directly into a webpart on a page within SharePoint. This page also contains webparts for links to corisponding documents and a survey.

To embed the videos I performed the following steps:

• Create a Webpart page with a general layout.
• Add a Content Editor Webpart.
• Select Source Editor in the Content Editor
• Input the following script in the Source Editor:

p align="center">

OBJECT id=playera height=575 width=650
CLASSID="clsid:6BF52A52-394A-11D3-B153-00C04F79FAA6"
ID="WMP">

PARAM NAME="URL" VALUE="mms://192.168.0.92/outlook2007.wmv">

PARAM NAME="AutoStart" VALUE="false">
/OBJECT>

• In my example above you will need to add a <>
• Change the "URL" VALUE= to point to your own video. Ours points to a media streaming server on our network.