Uploading your Project to a Host - Page 2

Go back to the first part of this article: Page 1

Moving the Data
With the schema now in place there are several methods that can usually be used to move your data. This could easily be an entire article but we will assume that you don't have any image or text fields in your database. If you do, about the only way to move the data is to create a helper page or use the website itself to reinsert these fields manually. For numerical and varchar fields, the process is simpler because we can use SQL Server to export our data to flat text files (csvs) and then have the GoDaddy SQL manager import these.

Unfortunately there isn't a quick way from the UI to export all tables at once unless you write some code to do so. Here, we will cover the one at a time method.

Here is a step by step on how to export an table. First select export and then your data source, which is a SQL Server, and a destination which we want to be a flat file.

We select the simple option of copying the entire table and press the Next button to get to the Execute dialog. If you think you will need to do this later you might consider saving you work as an SSIS package so that later you don't have do the wizard again.

Finally using the GoDaddy SQL Managment tool select the CSV File Import option

Repeat this for each of your tables and you will have a complete copy of your website. In summary this article has discussed one approach to uploading your website in the absence of automatic tools such as Visual Studio to do the synchronization and direct SQL Server connections. A more complete solution might involve coding up some custom tools to automate creating the flat files or in many cases you may not even need to upload data itself as it will be user generated.