![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Sharing data between Oracle and MS SQL SA Topic Summary: How to share data from Oracle to an MS SQL based SA installation Created On: 18-Oct-2006 14:18 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I'm working an SA installation using MS SQL as the database. I have another EA system at another agency that I need to get information from. How do I get the data from Oracle into my SA repository? I don't need to send it back, the data they will provide is just informational. |
|
![]() |
|
![]() |
|
Is the other agency using SA?
If so they could use the export XML facility from SA for the parts you are interested in. This can then be imported into your SQL encyclopedia (I would always recommend backing up your destination encyclopedia before doing this - in case you bring in more than you wanted). If the other agency is not using SA what are they using? We may already have a bridge to their product? Thanks Ian ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
quote: Yes they are. I did use the export but I was hoping for a more seamless approach. FWIW, I always back up the encyclopedia before doing any large imports just in case. I was looking for a way to get their entire repository in one pass as opposed to a series of files. e.g. to get the OV-5 info, I had to import the functions as a CSV and then import the XML for the diagrams. In our repository, we have extensive customization to the activities to track other data and that approach wouldn't work if the data structures were wrong. Since they use an Oracle Repository and we use SQL, it's not as simple as just creating a database .BAK file which is how we internally exchange encyclopedias. SN |
|
![]() |
|
![]() |
|
Hi
You can migrate an Oracle ency to a SQL ency if this helps (and vice versa). I suggest using a backup of the original Oracle ency just in case one time you get the destination wrong (it has happened!). The destination will be totally overwritten and you will get no warning. Instructions for SAMigrate :- Using a BACKUP of the Oracle Encyclopedia, use SAMIGRATE to get the encyclopedia from Oracle into SQL Server. 1. Create a new empty encyclopedia in SQL Server, using the default configuration. Make a note of its name and the server name. 2. Close SA 3. Run SAMigrate.exe from the SA install directory 4. Set the source as the BACKUP Oracle encyclopedia. 5. Set the target as the newly created SQL encyclopedia. 6. Set the security/usernames and passwords as necessary. 7. The dialog should look similar to above. (sorry couldn't insert the picture) 8. Press OK. 9. When it is complete the SQL Server encyclopedia should be an exact copy of the original Oracle Encyclopedia.
------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
I'm using samigrate.exe. I'm using it to migrate from Oracle to MSSQL for a client - works really well.
Cam Edited: 22-Jun-2007 at 00:48 by Cam Chapman |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.