Can I run the database script manually to create the EPiServer database?
Versions:
n/a,
FAQ number:
37,
Old FAQ number: 914
Q: Can I run the database script manually to create the EPiServer database?
A: Yes, you can. The recommended way is to run the EPiServer Installer utility, but if you for some reason have to run the database script manually (for instance because of collation problems), you can do so.
Note that the script file is Unicode and cannot be opened and read into Query Analyzer as is, because the Query Analyzer can not read Unicode files correctly. You need to open the script file in some other application like Notepad and save it as ANSI, or you can just open the script file in an editor and copy & paste it into Query Analyzer. Once the script is inside Query Analyser you can verify that the script has the right format by locating some Swedish characters (åäö). You may then run the script. Remember to run "iisreset" after you recreate the database to see the changes in affect.