Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
baarsd Absent Member.
Absent Member.
1445 views

Migrate from Oracle DB to MSSQL DB?

Hi all,

I was wondering if there is any tool available to migrate a zcm oracle database to mssql? I see there is a tool provided by MS

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

but does anyone know if zenworks would be happy with this type of migration?

Thanks!
Labels (2)
0 Likes
3 Replies
Micro Focus Expert
Micro Focus Expert

Re: Migrate from Oracle DB to MSSQL DB?

There is nothing from Novell to facilitate this and I suspect the MS
Tool would fail.

I know that Novell has put alot of Effort into trying to create a tool
to go from Sybase to MS-SQL, but the task has been very difficult.

I suspect if the MS Tool for Migrations worked well, then it would have
been used to assist folks getting of Sybase. (They have tools for
multiple operating systems.(

That being said, I doubt Novell has tested the Oracle -> MS-SQL Tool
Specifically.



On 3/2/2011 3:36 PM, baarsd wrote:
>
> Hi all,
>
> I was wondering if there is any tool available to migrate a zcm oracle
> database to mssql? I see there is a tool provided by MS
>
> http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx
>
> but does anyone know if zenworks would be happy with this type of
> migration?
>
> Thanks!
>
>



--
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
baarsd Absent Member.
Absent Member.

Re: Migrate from Oracle DB to MSSQL DB?

OK thanks Craig. Another question, do you know if it's possible to migrate from Oracle back to the internal zenworks database?
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Migrate from Oracle DB to MSSQL DB?

Unfortunately, the only migration option available at all is from Sybase
to Oracle.

No other options exist to or from any other platforms.

Other Direct DB Migration options are being examined as well as various
other tools for synching stuff between zones is being worked on, but I
do not know when any of this stuff may happen, but I would not hold
great expectations for much in the very near-term.

I have heard very little about customers wanting to migrate From Oracle,
so that is likely not very soon but I do not know that for sure.

What is more likely are tools to make it easier to migrate bundles and
policies between zones. I do not have any estimate of when this may
happen either, but its the type of thing that is requested with greater
frequency so more likely to happen.

When the Beta of ZCM 11 SP1 ships, likely soon, we may have a glimpse of
what is coming in the short-term.

On 3/6/2011 3:36 PM, baarsd wrote:
>
> OK thanks Craig. Another question, do you know if it's possible to
> migrate from Oracle back to the internal zenworks database?
>
>



--
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.