Ian Blackburn

Convert SQL 2005 to SQL 2000 Part II

In response to my previous post, I have just spotted the new "Publish to Provider" option in VS2008 server explorer.  It builds a script to recreate the db together with the data, and has an option to target 2000 – pretty easy solution all round...

Cheers

Ian

Convert SQL 2005 db to SQL 2000

I recently had to do this, and had to scratch my head a bit.

Anyway here is the path I took

1. I created an empty db in sql 2000
2. Generated a create db script for the sql 2005 db using management studio (Right click on DB > Tasks > Generate Script), including all objects in the selected db.  There is also an option in this wizard: Script for Server version, which I set to SQL 2000 
3. Ran the script on the sql 2000 db to create the empty database
4. Used SQL Data Compare from Red gate to copy the data across (guess I could have used SQL Compare from red-gate instead of step 2 and 3 also).  Other products are available (some free) that could also have done this step.

HTH

Cheers

Ian

Simple Silverlight Controls: Hyperlink

Until we get the controls for silverlight 1.1 you need to create your own.  This is actually reasonably easy once you know how.  Tim Heuer has a nice example of a glassy button.  But I thought it might be useful to have more examples out in the wild.  So I am going to publish a few here every now and then.  These are not commecial quality controls, just starting points for you to develop.

First up is a Hyperlink control. 

This is pretty simple, just a TextBlock and an animation to show some tool tip text.  Clicking the button calls HtmlPage.Navigate - to the NavgateUrl property I have added to the control.

• Source is here
• Demo is here

Have fun - any questions let me know.

Cheers

Ian

Simple Silverlight Streaming with the Encoder Plugin

This is worth a look.

A simple plugin to Expression Encoder that makes it trivially easy to publish your encoded content to the Silverlight Streaming service.  This wasn't that hard to do manually before, but it was a bit fiddly.  Now its a simple question of completing the following dialog. 

Your encoded content will be uploaded with the created manifest, and it will generate the iframe code you will need to include on your web page.  In addition you get to see existing streaming applications you have created, see the iframe code, preview it, and delete it.  Now we just need Microsoft to change that rather crude 22MB limit for video files to something more meaningful.

Get it from here

Cheers

Ian