This is actually fairly easy if you're use the Windows version of BOBJ:
1. Create a separate SQL Server databases for your CMS and Audit databases. Use the information about them to create 64-bit ODBC connections to them on the server where your BOBJ is installed.
2. Run the Central Configuration Manager (CCM). Right-click on the SIA. There should be an option to change the database there. Doing that will create the new tables in the CMS database and copy over all of the data to the new database. NOTE: You'll need to know your Cluster Key in order to make this happen.
3. To move the audit database, go to Auditing in the CMC and change the connection so that it connects to your new database - it should create the tables. However, you'll probably have to manually copy and old data over - you might export each table from SQL Anywhere to Excel and then upload the data to SQL Server using the Import function.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.