Hi
Anybody knows a best practice to migrate Repositories from MS SQL DB to Sybase Databases?
I have planned to install new BODS 4.2 environment on new servers (Windows 2012) on Sybase databases/Repositories and migrate repositories from my current (old) environment BODS 4.2 on MS SQL 2008 Databases to the new environment.
I searched Help.sap.com but I have been able to find anything use full yet.
BR
Peter
PDOLM (BOB member since 2013-05-10)
You would create an export of the SQL Server repository to an ATL file using Designer. Then you would import the ATL file into the ASE repository (after using Repository Manager to create the repository). This is by far the easiest way to go and I would absolutely try this method first. It will work for a local repository. It will not work for a Central Repository because all you get in the ATL file from a Central Repository is the latest version of each object - no history of each object makes it into the ATL file.
Moving Central Repositories to different DBMS types is painful. However, in your case the MS SQL Server and Sybase ASE architectures are very similar. I would do something like this:
You could use the Repository Manager utility to create the DDL in ASE. But it will also populate some default data in the tables. That default data is already in your SQL Server repository and there will likely be duplicates if you try to make a direct copy of the data from SQL Server to ASE.
eganjp 
(BOB member since 2007-09-12)
Hi Jim
Thank’s a lot for your reply. The work around seems to be pretty simple. I’ll keep this thread updated if there are some issues during the migration.
PS: Do you now where I can find documentation from SAP regarding this?. I have searched in the install, upgrade and Admin guide, but I have not been able to find anything!.
Cheers
Peter
PDOLM (BOB member since 2013-05-10)
As far as I know there is no documentation to support moving a repository to a different DBMS.
eganjp (BOB member since 2007-09-12)