IWMS Access and SQL Edition installation and transformation _ database other

The first time after the iwms4.5 version of the runtime automatic SQL build table. The bottom is to convert Access version data to SQL database methods.

Note: Converting from access to SQL requires two versions of the same version number

If your database account is not a system account, please open dvnews.sql with Notepad to replace [dbo] as [your SQL account]

Finally, you need to modify the SQL database connection in web.config

The SQL connection string cannot appear "&", "<", ">" If you must use the "&", "<", ">" Replace

<add key= "sqlconnstring" value= "server=" (local); Uid=sa; Pwd=1111;database=dvnews "/>

where (local) is the database server address, native
SA is the database user name
1111 for the database password
Dvnews for Database name