doc related to migration of DB oracle to sql serve

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

doc related to migration of DB oracle to sql serve

Author

Topic

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-25 : 23:36:16

is there any document or pdf which will help for migration oracle database to sql server 2008 database including all things like cursor, stored procedures how to convert it with example........

my requirement is "without using tool how to migrate oracle database to sql server database " according this is there any document present online

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-09-26 : 00:10:57

Some Microsoft documents on migrating to SQL Server, there's an Oracle version:

http://technet.microsoft.com/en-us/library/ee384251%28v=sql.100%29.aspx

quote:
my requirement is "without using tool how to migrate oracle database to sql server database "

Why can't you use a tool? The Migration Assistant is free:

http://www.microsoft.com/en-us/download/details.aspx?id=42655

And has full team support:

http://blogs.msdn.com/b/ssma/

It's not perfect, but it's better than trying to migrate everything from scratch. You can certainly use it to better understand the differences between the products and how to translate features.

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-26 : 05:15:14

means there is not such a document which will help me....

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-29 : 03:30:29

nobody is there?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-09-29 : 07:23:14

Taj-

We're here, and we're trying to help, but you are providing ZERO information on what you're trying to do, and what you've accomplished so far. We can't work in a vacuum. Your other threads are similar, we've had to ask repeatedly for even the most basic information.

I've forwarded a link to Microsoft's Oracle migration documentation. Have you read it? Is there something it's still not answering for you?

Are you migrating a single Oracle database? How large is it? What does this database do? Why are you migrating from Oracle to SQL Server?

Have you tried using the migration assistant? If yes, did it work for you or not? Give us specifics about what SSMA didn't accomplish. Did you check the team blog for answers?

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-29 : 09:16:28

i am migrating oracle dB to sql server and this is my job...
i am facing some difficulties in migrating XML code in sql server and also sys_refcursor migration problem

here it is code having XML if u can pls guide me to migrate me in sql server

thanx a lot to be for me

code is below........................

procedure usp_get_messages(p_application_id in number,
p_errors out sys_refcursor,
p_iserror out number)
is
e_invalid_application exception;
v_is_valid_application pls_integer;

begin

p_iserror := 0;

select count(*)
into v_is_valid_application
from tbl_error_messages
where application_id = pkg_atnot_configs.c_application_id;

if v_is_valid_application = 0 then
raise e_invalid_application;
end if;

open p_errors for
select xmlelement("errormessages",
( select xmlagg(
xmlelement("message", xmlattributes(error_no ,
description,
severity )
)
)
from tbl_error_messages
where application_id = application_id)
) as xml
from dual;

exception
when e_invalid_application then
p_iserror := 1;
pkg_exception_handler.usp_raise_error(-20999,pkg_atnot_configs.c_application_id,': Invalid Application (' || p_application_id || ')');
when others then
p_iserror := 1;
pkg_exception_handler.usp_raise_error(-20999,pkg_atnot_configs.c_application_id,'pkg_atnot_main.usp_get_messages');

end usp_get_messages;

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-30 : 04:57:41

no body is there

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources