Service Desk Practitioners Forum
cancel

SD 4.5 SP data base migration

SOLVED
Go to solution
Highlighted
William_157
Honored Contributor.

SD 4.5 SP data base migration

Hi;

We have SP4.5 SP17 running in Win2000 Server and SQL 2000 Server and planning migrate to HP-UX and Oracle 9i. How I migrate SQL to Oracle 9i.

Thanks
7 REPLIES
Vasily Kamenev
Acclaimed Contributor.
Solution

Re: SD 4.5 SP data base migration

Hi
Try backup your DB from MSSQL to flat file using sd_dbconfigwizard -internal and restore to Oracle.

Vasily
William_157
Honored Contributor.

Re: SD 4.5 SP data base migration

What do you meen with flat file.
Vasily Kamenev
Acclaimed Contributor.

Re: SD 4.5 SP data base migration

HI
That mean the file where infromation saved as one by one, the same as csv format by without separators.

Vasily
William_157
Honored Contributor.

Re: SD 4.5 SP data base migration

Hi;

Thanks for you help, but when i run the backup i received this error in the attachment.
Mark O'Loughlin
Acclaimed Contributor.

Re: SD 4.5 SP data base migration

Hi,

is it possible to stop and restart the application servers and then try the command again? This is a common error with them when they are set to the default memory allocations.

I haven't seen the error with the command you are using but it might be worth try.
William_157
Honored Contributor.

Re: SD 4.5 SP data base migration

Hi

I try running the backup with sd_dbconfigwizard -internal but I received a memory error. Any ideas.
William_157
Honored Contributor.

Re: SD 4.5 SP data base migration

Thanks