Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 18-Oct-2006 14:18
User is offline View Users Profile Print this message


Steven Nichols

Posts: 2
Joined: 18-Oct-2006

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.

They have offered to give me either a Schema with the data included or just sent me the files via XML.  I know how to use the XML exports but I have no idea what I would do with the schema since I have no idea if an Oracle schema would be importable to the MS SQL.

Thoughts?

Steven Nichols

Report this to a Moderator Report this to a Moderator
 19-Oct-2006 09:30
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

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.
Report this to a Moderator Report this to a Moderator
 19-Oct-2006 12:44
User is offline View Users Profile Print this message


Steven Nichols

Posts: 2
Joined: 18-Oct-2006

quote:

Originally posted by: SA Team
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


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
Report this to a Moderator Report this to a Moderator
 19-Oct-2006 13:00
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

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.

 

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 22-Jun-2007 00:41
User is offline View Users Profile Print this message


Cam Chapman

Posts: 18
Joined: 15-Jan-2007

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
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 0 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 0 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.