»Iscriviti   »Guestbook   »Immagini   »Forum   »Download   »Mappa   2036 utenti on line
MENU

SVILUPPO

RISORSE

Login

Suggerimenti

 
Forum
Use Different Database
Indietro indietro   Registrati registrati  
Autore Thread
 giardina
Moderatore
 
Località: Putignano
Nazione: Italy
Web: http://www.media.it
 
Use Different Database

Many customer ask via email more details about can be use different database.

Store Portal can be use more different database; MS Access is installed startup database but you can switch on different database after the installation process.

For do it, apply this simple step.

MySQL Step
========
1) Install MySQL Server on Linux or Windows 2000
2) On the home server of your store portal web site install MyODBC library
3) Create a New Database empty on MySQL Server.
4) Create a New User with password on MySQLServer, with all permission on new database created.
5) NOT CREATE TABLE !!! in database, Store Portal migration process do all.
6) Create a new ODBC connection, type System, on store portal homed server. The Name of the ODBC connection is important.
7) Open your Store Portale site. Do in administrative area and select Tools.
8) Select now Copy Database. From Access database to ODBC Database. Complete all required field: Name of the ODBC connection, Login and Password.
9) Now Copy process open MySQL database and create all table. After copy all data from Ms Access to MySQL database. If all is ok the procedure look Copy Complete.
10) Now do in Setting Menu of Store Portal, open Database Setting and change setting, from access to odbc.

Enjoy you have migrate emoticon .

Giuseppe Giardina
Support Manager
Store Portal Inc.

 01.10.2003
Registrati registrati