Pablo Castro, the Program Manager of the ADO.NET team, posted some great code samples from his PDC presentation. There are a variety of demos available. The one I spent the most time playing with was the one that used BCP on the client to bulk insert back to the server. If you need to move large amounts of data from the client to the server it's definitely worth a look.
Scriptio is updated to 0.5.2. This version offers better support when switching servers. It also provides a friendly error message if you choose a SQL Server 2000 server.
Update: Most recent install and source code: http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx