Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set. Other collations will sort in different orders. For example, a traditional Spanish collation places words beginning with “ch” at the end of a list of words beginning with “c.”
It is not necessary to [...]
ASP.NET starter kits can be downloaded from the ASP.NET website.
The following instructions use the ASP Time Tracker starter kit as an example. However, you can use this upload procedure for any starter kit that uses a SQL database (running from a local MDF file or a standalone server). The directions assume the following:You have [...]
For security reasons, you cannot directly publish assemblies. However, it is possible to publish a database using assemblies through the Database Publication Wizard (DPW).
To Publish a Database Using AssembliesLog in to your Account Manager.
In the My Products section, select Hosting.
Click Manage Account next to the hosting account you want to modify.
In the Databases section of [...]
It is not possible to publish a full text catalog to one of our hosted SQL databases. For additional information about the Database Publishing Service limitations, see
Limitations of the Database Publishing Service in the Shared Hosting Environment.
The Database Publishing Wizard (DPW) project home page is located in the CodePlex SQL Server Hosting Toolkit .For additional information about the Database Publishing Service and the Database Publishing Wizard, see the following articles:What are the Database Publishing Service and Database Publishing Wizard?Where do I get the Database Publishing Wizard client?
The Database Publishing Wizard (DPW) provides detailed errors when you may be able to resolve them unassisted. If an error occurs that cannot be resolved without support, you will receive a more generic message. The following error messages are the most common ones you may receive during the publishing process.
Connection Errors
You [...]
To set up the Database Publishing Wizard, you will need the following information:FTP User Name/Password
The FTP account must own the target database or publishing will fail. If you have multiple hosting accounts, you must use the FTP user information for the account owning the database.
Database User Name/Password
You can find the user name [...]
Using your login credentials, you can perform all database actions through the Database Publishing Wizard (DPW). As such, you cannot perform any activity that is prohibited under normal usage, such as creating or modifying full text catalogs, assemblies, or database level triggers.
If you attempt to publish a database with any of these items, it [...]
The URL for the Database Publishing Service (DPS) is located in the Database Information section of your Hosting Control Center.To Locate the URL for the DPSLog in to your Account Manager.
In the My Products section, select Hosting.
Click Manage Account next to the hosting account you want to modify.
In the Databases section of the Hosting Control [...]
The latest version of the Database Publishing Wizard (DPW) client is available from the CodePlex SQL Server Hosting Toolkit.
To Download the DPWOpen the CodePlex SQL Server Hosting Toolkit in a browser window.
Click Download the Current Release.
Click Download.
Click Save and select a location on your local system.To Install the DPWLocate the install package [...]
The Database Publishing Wizard (DPW) client works with all local versions of SQL Server and supports publishing to both 2000 and 2005 databases. The DPW client automatically sets the Script for target database version to the correct version when publishing to the hosted Database Publishing Service (DPS).
When publishing to SQL Server 2000, [...]
The Database Publishing Wizard (DPW) runs under your hosting account credentials. Therefore, you can publish any object that you have permission to create using SQL script, with the exception of the following:Full Text Catalogs
Additional Database Users (The DPW will script any users as roles.)
Assemblies (These can be uploaded manually using the Web Manager for your [...]
The Database Publishing Service (DPS) may alter the contents and structure of your database. Depending on the options you choose, it may overwrite existing data. You cannot recover any lost data without a database restore from an existing backup file.Drop Existing Objects in Script
By default, the Database Publishing Wizard (DPW) attempts to drop [...]
The Database Publishing Service (DPS) and Database Publishing Wizard (DPW) are a set of tools that enable direct publishing of a SQL Server database from a client computer to a hosted database within the shared environment. Databases are published as batches of SQL script files using your database credentials. Any actions you have permissions to [...]
When restoring a SQL Server database back-up file, you are limited to using .bak files that you created using the back-up feature in our Hosting Control Center. You are not able to restore a .bak file that was created outside of our system. There are several reasons we have established this restriction:Based on the Microsoft® [...]