transfer_sqlserver.properties
############################################################################## # # WebSphere Portal 5.1 configuration file for database transfer: # From: Cloudscape # To: Microsoft SQL Server # # NOTE: Do NOT enclose any value in quotes! # NOTE: Windows paths must use '/', not '\'. # NOTE: Windows long paths are OK. # NOTE: Properties are immutable. Once set, they cannot be overriden. # ############################################################################### ############################################################################### # # How to use this file: # # 1. Consult the Information Center for detailed instructions on the properties and tasks # listed in this file: # Configuring> Database(Windows/UNIX)> Configuring Databases> SQL Server # 2. Change into the <wp_root>/config directory # 3. Edit this file to match your environment # 4. Import the contents of this file into wpconfig.properties: # on Windows: # WPSconfig -DparentProperties="<full_path_to_this_file>" -DSaveParentProperties=true # # on other platforms # ./WPSconfig.sh -DparentProperties=<full_path_to_this_file> -DSaveParentProperties=true # 5. Test connections to databases: # on Windows: # WPSconfig validate-database-connection-wps # WPSconfig validate-database-connection-wmm # # If you have configured CM and Personalization (configured by default), also test those connections: # WPSconfig validate-database-connection-jcr # WPSconfig validate-database-connection-feedback # WPSconfig validate-database-connection-likeminds # # on other platforms # ./WPSconfig.sh validate-database-connection-wps # ./WPSconfig.sh validate-database-connection-wmm # # If you have configured CM and Personalization (configured by default), also test those connections: # ./WPSconfig.sh validate-database-connection-jcr # ./WPSconfig.sh validate-database-connection-feedback # ./WPSconfig.sh validate-database-connection-likeminds # # 6. Import data to the target databases: # on Windows: # WPSconfig database-transfer # # on other platforms # ./WPSconfig.sh database-transfer ############################################################################### ############################################################################### # Database Properties - BEGIN ############################################################################### # DbSafeMode: This only applies to Database specific tasks. If it is set to true # the databases will not be created, initialized, or removed. # { false | true } DbSafeMode=false # DbType: The type of database to be used for WebSphere Portal DbType=sqlserver # DbDriver: The name of class SqlProcessor will use to import SQL files, also known as "JDBC provider" DbDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver # DbDriverDs: The name of class SqlProcessor will use to import SQL files via data source DbDriverDs=com.microsoft.jdbcx.sqlserver.SQLServerDataSource #DbLibrary: The directory and name of the zip file containing db.driver class DbLibrary=<SQLServerJDBC>/lib/mssqlserver.jar;<SQLServerJDBC>/lib/msbase.jar;<SQLServerJDBC>/lib/msutil.jar ############################################################################### # WPS Database Properties - BEGIN ############################################################################### # WpsDbName: The name of the WebSphere Portal database # Note: This value should also appear as the database element in DbUrl WpsDbName=wpsdb # DbUrl: The wps database URL # Note: The database element of this value should match the value of WpsDbName DbUrl=jdbc:microsoft:sqlserver://<SQLSERVER_HOST>:1433;DatabaseName=wpsdb # DbUser: The database administrator user ID DbUser=<DbUser> # DbPassword: The database administrator password DbPassword= ################################################################## # WMM Properties - BEGIN ################################################################## # WmmDbName: The name of the WebSphere Portal database # Note: This value should also appear as the database element in WmmDbUrl WmmDbName=wpsdb # WmmDbUser: The database administrator user ID WmmDbUser=<WmmDbUser> # WmmDbPassword: The database administrator password WmmDbPassword= # WmmDbUrl: The database URL # Note: The database element of this value should match the value of WmmDbName WmmDbUrl=jdbc:microsoft:sqlserver://<SQLSERVER_HOST>:1433;DatabaseName=wpsdb ################################################################## # WMM Properties - END ################################################################## ################################################################## # JCR Database Properties - BEGIN ################################################################## # JcrDbName: The name of the WebSphere Portal database for JCR tables # Note: This value should also appear as the database element in JcrDbUrl JcrDbName=jcrdb # JcrDbUser: The JCR database administrator User ID/schema name JcrDbUser=<jcr_db_user> # JcrDbPassword: The JCR database administrator password JcrDbPassword= # **Required when using sqlserver only** # JcrSaDbPassword: The SQL Server sa password JcrDbSaPassword= # JcrDsName: The name of datasource to be used for JCR JcrDsName=JCRDS # JcrDbUrl: The JCR database URL # Note: The database element of this value should match the value of JcrDbName JcrDbUrl=jdbc:microsoft:sqlserver://<SQLSERVER_HOST>:1433;DatabaseName=jcrdb # Debug level for JCR database utilities JcrDebugLevel=2 # JcrDbUnicode: Indicates whether or not the JCR database is unicode. # Y: is unicode # N: is NOT unicode JcrDbUnicode=Y ################################################################## # JCR Database Properties - END ################################################################## ################################################################## # Personalization Database Properties - BEGIN ################################################################## # **Required for MS SQL Server only** # FeedbackDbHostName: The hostname of the feedback database. FeedbackDbHostName=<FeedbackDbHostName> # FeedbackDbName: The name of the feedback database. # Note: This value should also appear as the database element in FeedbackDbUrl FeedbackDbName=fdbkdb # **For SQL Server and Oracle only, this value MUST be set to FEEDBACK** # **which corresponds to the user FEEDBACK in your SQL Server or Oracle database** # FeedbackDbUser: The database user for feedback database. FeedbackDbUser=FEEDBACK # FeedbackDbPassword: The database password for feedback database. FeedbackDbPassword= # FeedbackDbUrl: The Feedback database URL # Note: The database element of this value should match the value of FeedbackDbName FeedbackDbUrl=jdbc:microsoft:sqlserver://<SQLSERVER_HOST>:1433;DatabaseName=fdbkdb # **Required for MS SQL Server only** # LikemindsDbHostName: The hostname of the Likeminds database. LikemindsDbHostName=<LikemindsDbHostName> # LikemindsDbName: The name of the Likeminds database. # Note: This value should also appear as the database element in LikemindsDbUrl LikemindsDbName=lmdb51 # LikemindsDbUser: The database user for Likeminds database. LikemindsDbUser=<likeminds_db_user> # LikemindsDbPassword: The database password for Likeminds database. LikemindsDbPassword= # LikemindsDbUrl: The Likeminds database URL # Note: The database element of this value should match the value of LikemindsDbName LikemindsDbUrl=jdbc:microsoft:sqlserver://<SQLSERVER_HOST>:1433;DatabaseName=lmdb51 ################################################################## # Personalization Database Properties - END ##################################################################WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.
IBM is a trademark of the IBM Corporation in the United States, other countries, or both.