The easiest way to upload a database to dotster is to use the sql hosting toolkit. Visual studio 2008 installs the sql hosting toolkit for you otherwise you need to download and install from the link.
Steps to do this
1) Create a database in the dotster control panel.
2) In the server explorer create a link to the database you want to upload.
3) Right click on the database and select publish to provider in the wizard make sure you select sql 2000 as the target database schema.
4) On the codeplex website they use to have a webpage available to use to help run the script to create your database. Now they have a webservice for this. I kind of think the webservice is over kill to just publish 1 database. So create a c# website which targets the .net framework 2.0
5) Add the script file you created in step 3 to the website.
6) Add the following code to webpage
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using System.Web;
using System.IO;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
namespace WebApplication3
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string fileName = Server.MapPath(@"<<YOUR_SCRIPTFILE>>.SQL");
// Connection string to the server you want to execute against
string connectionString = @"Server=<<YOUR_SERVER>>;User ID=<<YOUR_USERNAME>>;Password=<<YOUR_PASSWORD>>;Initial Catalog=<<YOUR_DATABASE>>";
// Timeout of batches (in seconds)
int timeout = 600;
SqlConnection conn = null;
try
{
Response.Write(String.Format("Opening file {0}<BR>", fileName));
// read file
using (StreamReader sr = new StreamReader(new FileStream(fileName, FileMode.Open)))
{
Response.Write("Connecting to SQL Server database...<BR>");
// Create new connection to database
conn = new SqlConnection(connectionString);
conn.Open();
while (!sr.EndOfStream)
{
StringBuilder sb = new StringBuilder();
SqlCommand cmd = conn.CreateCommand();
while (!sr.EndOfStream)
{
string s = sr.ReadLine();
if (s != null && s.ToUpper().Trim().Equals("GO"))
{
break;
}
sb.AppendLine(s);
}
// Execute T-SQL against the target database
try
{
cmd.CommandText = sb.ToString();
cmd.CommandTimeout = timeout;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(sb.ToString().Replace("\n", @"<br/>"));
Response.Write(ex.Message.ToString() + @"<br />");
}
}
}
Response.Write("T-SQL file executed successfully");
}
catch (Exception ex)
{
Response.Write(String.Format("An error occured: {0}", ex.ToString()));
}
finally
{
// Close out the connection
//
if (conn != null)
{
try
{
conn.Close();
conn.Dispose();
}
catch (Exception e1)
{
Response.Write(String.Format(@"Could not close the connection. Error was {0}", e1.ToString()));
}
}
}
}
}
}
Uploasd the website to dotster and open the webpage and your database should be copied to the new database. Make sure you delete the website after you created the database to prevent someone from accidently undo changes to the database after you uploaded it.