on 03-30-2010 8:10 AM
We are using MaxDB 7.6 with content server 6.40 for DMS. and we would like to change the database to MSSQL.
is there any tool or a way to migrate our MaxDB to MSSQL?
> We are using MaxDB 7.6 with content server 6.40 for DMS. and we would like to change the database to MSSQL.
I'm sorry - wrong information.
The content server works solely with MaxDB - so no, no migration possible.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> but if there is a tool for migration. i might take another senario and use the archivelink to connect to MSSQL and use it as a storage for DMS.
There is no tool for the migration to another database. The mentioned tool (loadercli) is part of the MaxDB database.
You can, however, migrate to a flat file webserver instead of using a database:
Note 688241 - Relocating large SAP Content Server Repositories
Markus
Just to clarify: Our concern is not about Content Server, it is about MaxDB.
The only usage for MaxDB is to be used to store DMS Originals, which are the files inside DMS DIR. the rest of the infrastructure is using MSSQL (Microsoft exchange, MS DC, MS AD, Helpdesk, SAP, Sharepoint, SAP Portal).
also when talking about enterprise monitoring we have to get two license for MSSQL and MaxDB.
for Backup agents we need to get two license for MSSQL & MaxDB.
Maintenance, Operation, Updates, administration, will be twice for MSSQL & MaxDB.
not mentioning that the licenses for MaxDB with Third Parties is much much expensive than MSSQL license.
since the only usage for MaxDB is as DMS storage, so why not to migrate it to MSSQL and unify our infrastructure.
please share your thought if there is a way to use MSSQL for DMS instead of MaxDB
> Just to clarify: Our concern is not about Content Server, it is about MaxDB.
I understand your arguments - but there is no possibility to install a content server on MS-SQL.
You have two options to install a content server:
- with a database backend - only MaxDB is supported
- using flat files on a webserver.
Markus
as per my knowladge that content server is not a must to run DMS.
so the scenario i have came up with, is to create a repository with RFC connection as ArchiveLink to MSSQL. and use it as DMS repository.
http://help.sap.com/saphelp_nw04s/helpdata/en/ed/cefa3882cd8229e10000000a11402f/frameset.htm
then relocate all Content Server repository content to it
SAP Note : 688241
anyway is it a close to a solution?
> The only usage for MaxDB is to be used to store DMS Originals, which are the files inside DMS DIR. the rest of the infrastructure is using MSSQL (Microsoft exchange, MS DC, MS AD, Helpdesk, SAP, Sharepoint, SAP Portal).
>
> also when talking about enterprise monitoring we have to get two license for MSSQL and MaxDB.
Correct, but the MaxDB license and the resulting maintenance fees are lower than for MSSQL.
> for Backup agents we need to get two license for MSSQL & MaxDB.
Don't know what backup agents you use - but the standard interface programs for ADSM, Networker etc. work with MaxDB.
> Maintenance, Operation, Updates, administration, will be twice for MSSQL & MaxDB.
The overall effort for MaxDB is usually less than for MSSQL.
> not mentioning that the licenses for MaxDB with Third Parties is much much expensive than MSSQL license.
?? What are you talking about here?
MaxDB comes for free in the Community Edition.
> since the only usage for MaxDB is as DMS storage, so why not to migrate it to MSSQL and unify our infrastructure.
> please share your thought if there is a way to use MSSQL for DMS instead of MaxDB
As Markus already said with Content Server it's either database storage (MaxDB) or Filesystem.
regards,
Lars
No offense sir.
I didnu2019t come here to evaluate which one is better, or to convince me that MaxDB is better.
i'm not evaluating and I have no right to judge, i'm just answering your question. There are a lot of analysis companies that has this kind of statistic and they are expert in this area.
What concern me is that I have a company requirement, regardless of what is the best scenario or usage.
thanks for the information you have provided and your efforts
Hello Abdulaziz,
1) As you already know, the SAP content server 6.40 is supported with MAXDB database.
Please review the SAP Product Availability Matrix.
2) Itu2019s MAXDB/liveCache forum.
If you have any problems with MAXDB database or would like to migrate another database to MAXDB, we are welcome to help you. Just post your questions/problems in this forum.
As you posted in this forum, that you have some problems with MAXDB, we would like to get clear on the MAXDB issues and help you to find the solution for your bisness scenario.
And u201CMigrate MaxDB to MSSQLu201D topic is for u201CSAP on SQL Serveru201D forum.
Thank you and best regards, Natalia Khlopina
Edited by: Natalia Khlopina on Mar 30, 2010 11:23 AM
Check
Note 962019 - System copy of MaxDB Content Server Storage
you'll need to do the "loadercli" migration.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.