Change from Oracle to SQL

[otengineer]

I know this is out of left field and hardly practical but I have a request to change a Livelink 9.7.1 environment using Oracle 10g to SQL 2008.

What we're thinking of doing is standing up a new 9.7.1 environment with SQL in parallel to the existing environment. We then plan to export ALL content from the Oracle environment and import into the newly created SQL 9.7.1 instance.

I can't imagine how permissions will be retained but I know I can export content/metadata.

I'd like to hear what some of you experts think about this sort of request. This won't be easy and I've told the customer that I don't recommend this because not everything will be preserved exactly as it was. There's bound to be a loss in data/config/something!

Any tools you can think of to help export/import? Object Importer, Blubaker, Syntergy?

Thanks for your time.

 

[appnair]

The migration tools know how to handle permissions so long as you pre create named users and groups before hand.
You would get a list of all users+groups in source system.Then if you were using directory services in source and
target you would run the same query in the target so those identically named user groups are in the new system
Or you would code it with oscript,lapi,webservices et al.That goes for almost all the building blocks.Or in other words
things like categories,classifications,workflow maps et al.
GCI also has import/export things including audit trails.
Hopefully the client knows that the target objid's will change.syntergy I think has some logic that may allow you to
do this.If I were you I would contract a good company who knows in depth livelink and get it done.
Why move from Ora to SQL isn't ORA better at doing thisngs?

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[otengineer]

they want to move away from oracle due to licensing costs (from what i understand)

i have no problem completing this work myself - this project is a risk if you ask me and the customer knows this going into it. i've used gci products in the past, i'll reach out to jeff to see what tricks they have to handle this sort of effort.

 

[appnair]

The syntergy replicator may be even be able to preserve the dataids since the traget system is new and no dataid collision is expected just a thought Jeff may have the exact same thing as well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair