3. Import CMS Forum data to the SQL Server database

Teach you how to import the CMS Forum data to the SQLServer database lab environment: a company is a national chain brand enterprise with more than 200 people at Headquarters, 35 national institutions, and a total of more than 3300 people, the company's original website, due to business development needs, cannot meet the existing access requirements, need to expand. The requirements are as follows: create a WEB site

Teach you how to import CMS Forum data to the SQL Server data warehouse lab environment: a company is a national chain brand enterprise, with more than 200 headquarters and 35 national institutions, the total number of users is more than 3300. The company's original website needs to be expanded because it cannot meet the existing access requirements due to business development needs. The requirements are as follows: create a WEB site

Hand handleTeach you how to use CMSForumDataImportToSQL ServerDataLibrary

Lab environment:

A company is a national chain brand enterprise with more than 200 people at Headquarters, 35 national institutions, and more than 3300 people. The company's original website is required for business development, expansion is required because the existing access requirements cannot be met. The requirements are as follows:

Create a WEB site named [url] www.shopping.com [/url]. The website belongs to the CMS Online Shopping System, and allDataAll stored in SQL ServerDataLibrary.

Tutorial steps:

1. Set up an experimental environment

First, you need to build a dns server and create A host A record with the IP address 172.16.100.100 corresponding to [url] www.shopping.com [/url. If you do not set up a DNS server, you can also do not use domain name access.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Then, build a WEB site named "my store" in the site and access it using the Host Header, or IP address. COPY the source code in the attachment to the root directory of the website.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Set the default homepage of the site to index. asp. It does not exist by default and needs to be manually added.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Select "configuration" in "main directory" and enable "parent path" to select "script and executable file"

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Set the status of "Active Server Pages" and "ASP. NET v1.1.4322" in "WEB service extensions" to "Allowed"

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

2. Install PowerEasy SiteWeaver CMS in a WEB browser and enter "[url] http://www.shopping/install.asp#/url.pdf" in the web browser.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Enter the account, password, and verification code that the Administrator logs on. Refresh "HTTP 500 internal server error.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Enter the site property parameters. Note that the site address must be "[url] required.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

The following error occurs after you enter the information.DataLibrary security attributes, you needDataThe attribute of the database is modified to allow writing. For the sake of simplicity, an everyone is added and the home directory and sub-directories of the website have full write permissions.

Note:In actual use, you must pay attention to the permission settings. Accidental access may result in website hacking.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After setting, refresh the interface on the installation page and delete "Install. asp" as prompted. manually delete the interface if it is not deleted.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After deletion, you can use the system.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

You can also enter [url] http://www.shopping/admin/admin_login.asp#/url#in the backend management of the system on the WEB server.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Here, the dynamic site is basically set up, but allDataIt's just put on the site's ownDataLibrary.

3. Install SQL ServerDataLibrary, and set the Server Authentication Mode to "SQL Server and Windows Authentication Mode", and createDataThe database name is "shopping ".

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Create a login user named dreamfire and set its password. The default value isDataSelect "shopping" for the database, or use the system's built-in user SA. In actual applications, SA has a large permission, which is disabled by default. It is best to create a user and grant appropriate permissions.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

To facilitate testing, assign all server roles to dreamfire. In reality, it is absolutely not allowed.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

User ingDataDatabase shopping

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

The logon status is set to "enabled", and the default logon status of SA is "disabled ".

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After setting, restartDataLibrary to make the settings take effect.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

4,Change the WEBBackgroundDataLibraryImportTo SQLMedium

Open the folder Database in the web site and useDataOpen SiteWeaver. SQL in the database engine. Use the user dreamfire you just created to log on. For authentication, select "SQL Server Authentication"

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After logging on to the console, a list of table creation commands are displayed in the window.DataLibrary. Add "use shopping" before the command.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

"Data", And multiple tables are generated in the table.

Note:: Execution errors may be caused by user permissions.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

This dynamic website system uses ACCESS by default.DataLibrary as your own backgroundDataDatabase System, you need to change to SQL as your own default system, use DreamWeaver (you can also use the wordboard to open) Open Conn. asp under the web main directory, and follow the prompts to modify the parameters

Const SystemDatabaseType = "SQL"

Const SqlUsername = "dreamfire"

Const SqlPassword = "123.com"

Const SqlDatabaseName = "shopping"

Const SqlHostIP = "(local )"

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After the modification is complete, visit the site on the client and find that "this module cannot be found". You can copy the SiteWeaver. mdb module in the database (four modules by default) to the TEMP file.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Then add all modules in the backgroundDataLibrary, and then select one as the default.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Now you can access this WEB site,

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

5,Test SQL ServerWith WEBSite combination

To checkDataIf the database is actually attached to SQL Server, you can open "SQL Server Profiler" in "performance tool" and create a trail. Then register at the web site to seeDataAll trace results are displayed.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

After creating a user, you can go to shoppingDataView registered users in the table corresponding to the database.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

Use SQL ServerDataLibrary to Change User attribute parameters. (You can also modify it in the WEB site background)

For example, you can add the balance of xiaonuo to 1000.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

InDataCreate a new query in the database, point the query to shopping, and then run the update pe_user set balance = balance + 1000 where username = 'xiaonuo 'command.

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

650) this. width = 650; "onclick = 'window. open (" http://blog.51cto.com/viewpic.php? Refimg = "+ this. src) '>

This article is fromNetworkTechnical classroom]

This article is from 51CTO. COM technical blog