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.
Go to Top of Page

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-26 : 05:15:14
means there is not such a document which will help me....
Go to Top of Page

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-29 : 03:30:29
nobody is there?
Go to Top of Page

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?
Go to Top of Page

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;
Go to Top of Page

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-30 : 04:57:41
no body is there
Go to Top of Page
   

- Advertisement -