How to upload my local SQL 2005 databases to your servers?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000100 |
| Rating: |
|
3.7 / 5.0 (3 votes)
|
| Views: |
|
3191 |
|
How to upload my local SQL 2005 databases to your servers?
|
Please follow these steps to move your sql 2005 databases from local machine to our servers.
1) Download and install "Database Publishing Wizard" from http://www.codeplex.com/sqlhost.
2) Script all of your local databases as .sql files using "Database Publishing Wizard".
3) Connect your SQL Server Management Studio Express Edition to our SQL2005 database "xxx.xxx.xxx.xxx,####". You can download it from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796.
4) Execute these .sql files.
5) Change the connection string in Web.config as below.
<connectionStrings>
<add name="Personal" connectionString="Server=xxx.xxx.xxx.xxx,####;Database=yourdatabase;uid=yourusername;pwd=yourpassword;" providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Server=xxx.xxx.xxx.xxx,####;Database=yourdatabase;uid=yourusername;pwd=yourpassword;" />
</connectionStrings>
Your web site should be up and running.
|
