Migrate SQL Server Database to Oracle using SQL Developer

Подписаться 4,4 тыс.

Просмотров 27 тыс.

50% 1

This tutorial is about creating connection to Microsoft SQL Server 2008 using third party jdbc driver in Oracle SQL Developer and exporting database from SQL Server to Oracle database using export to oracle features in Oracle SQL Developer.
Source to download third party jdbc driver : sourceforge.ne...

Опубликовано:

6 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 42

@rocknshake Год назад

well explained and clear, thank you. I have a requirement to migrate from sql (sql server 2019) to oracle 12c, I tried to migrate using sql developer 19.2 but it is not working. As per the sql developer notes till sql server 2008 are only supported. Can you please help me in this regard? Thank you.

@SubhroneelGanguly Год назад

You suppose to use the compatible jar file. I will try to make a video on this give me some time

@rocknshake Год назад

@@SubhroneelGanguly Sure, thank you. Sorry for the late reply I just saw the message as it automatically filtered to social in gmail. :(

@digaoap 6 лет назад

Very good explanation, congratulations.

@SubhroneelGanguly 6 лет назад

Thanks

@durgaprasadsriramoji5111 4 года назад

@@SubhroneelGanguly Hi Sir, After the migration I am unable to connect with sqlserverdb name as a user and pwd, I also found that there's no such user/schema got created, pls help.

@arlenecarella3974 4 года назад

I loved your video. it was very helpful. However, my migration failed because the sql database has more tables and rows than the oracle database. would you be able to tell me how to restrict what is coming over from the sql database over to oracle. I was hoping a window would come up where they would be side by side and I would be able to deselect from sql tables what did not need to come across. The only thing I am migrating is data. Thank you so much for the awesome video. Arlene

@SubhroneelGanguly 4 года назад

Why you are not trying a fresh migration without anything on the target?

@satyakeerthi1040 5 лет назад

I have followed the same steps , but it's not working when I create a connection after the migration with same username and password. Anyone faced same issue , please let me know

@durgaprasadsriramoji5111 4 года назад

same issue here!!, in the demonstartion he used local orcl db where as in my case its Remote one, not sure does that differ.

@prasad014343 4 года назад

How can we selectively migrate the objects(tables,procs,func,pkgs etc.) rather than the entire database?

@P5toraskar1986 7 лет назад

COOL NICE VIDEO FOR MIGRATION.

@florincopaci6821 3 года назад

Hello! thank you for this channel and for all the things i have learned here. Maybe you can help me with an advice. I try to migrate some databases from sql server to oracle. I do almost everything-create a new user with all privileges, making a repository, connecting to sql server, migrate to oracle using oracle migration wizard, creating a folder for repository ,then convert and translate to oracle but nothing. It shows me-migrate successfully but when i make a simple select to see the data-nothing. Only the columns - name of the columns with no data. it brings me only the structure of the tables but no data. I get stuck and i do exactly the steps from the internet. I m able to pay because i want to solve this. Please. i forgot to say that i m using oracle 18c and sql developer 21.2.1 Thank you in advance

@SubhroneelGanguly Год назад

Hope you have already fixed the issue if not please let me know whether you are able to connect to SQL Server using sqljdbc driver.

@alktab8993 6 лет назад

Thank you

@geoffjollygeoff379 4 года назад

Hello sir after installing jdts from the below mention link you have given now we have to set path for jdts or simply it will take from oracle SQL developer

@SubhroneelGanguly 4 года назад

I didn't get your question. Did you added the jar file on third party driver?

@henryquartey-papafio2076 4 года назад

Unable to connect to schema as well. Seems like quite a few ppl are having the same hiccup.. Any advise ?

@SubhroneelGanguly 4 года назад

Please provide some details.

@mohammedafzal8004 4 года назад

Need your help for the following scenario : My sql server has multiple users and within each user DB objects (tables, view, procedures etc) are stored. Now, after migrating the SQL server DB to oracle i am unable to find the users and the objects within the users. However the summary of the migration shows those objects within the user.

@SubhroneelGanguly 4 года назад

Several questions arise. How you are checking your new user? Did you tried login with the new user? And cannot find the objects within?

@mohammedafzal8004 4 года назад

@@SubhroneelGanguly hi First of all thanks for your reply Here are the details My sql server db("testdb" as the name) has 5 users(user1 to user5) Using sql developer tool I migrated the "testdb" to oracle. Now under migration tab of sql server I see that the repository has successfully migrated the testdb to oracle with users but here the usernames are changed to "user1_testdb" to "user5_testdb". Now I tried to connect to my migrated db first I tried logging in oracle using "testdb" it failed stating username/login error Next I tried to connect using user1_testdb but this also failed I even tried user1 One more observation in db I cant see these users created under dba_users table

@anudipray4492 2 года назад

Will the stored procedure and functions also get migrated

@SubhroneelGanguly Год назад

Yes incase of full export

@elegeblege1618 7 лет назад

Unfortunatelly, latest jdbc doesn't support connect to Microsoft SQL Server 2016 :/

@SubhroneelGanguly 7 лет назад

+Juraj Beleščák Please do some research before coming to conclusion. Or you are thinking jdbc is obsolete???. LOL. www.microsoft.com/en-in/download/details.aspx?id=11774

@elegeblege1618 7 лет назад

+Subhroneel Ganguly I did. I also tried this jdbc 6.0 but there was problem i wasn't able to fix for long time. When i added the 3rd party jdbc driver, SQL Server tab in New connection window didn't appear.. I tried for jdk7 also jdk8, but still nothing. When I got added this MS JDBC 6 in the list, tried connection via custom url which i got from some documentation but also unsuccesfully. You can consider this as suggestion for new video :P

@worldstreetfood3747 6 лет назад

I have been trying to migrate 350 mb SQL server db...how long should it take.

@SubhroneelGanguly 6 лет назад

What is the method of migration? Try exporting as sql server object.

@tazuddin543 6 лет назад

Do you know is it possible or not to connect to Microsoft SQL Server 2016 ?

@SubhroneelGanguly 6 лет назад

Use jtds jar instead of sqljdbc jar

@tazuddin543 6 лет назад

This one ? doesn't work, it supports upto sql server 2012 jTDS - SQL Server and Sybase JDBC driver Overview Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5 up to 2012) and Sybase ASE. jTDS is a complete implementation of the JDBC 3.0 spec and the fastest JDBC driver for MS SQL Server. For more information see jtds.sourceforge.net/

@tazuddin543 6 лет назад

finally got it working in sql server 2008. thanks for your tutorial.

@sanjaynagpal4423 6 лет назад

what version of sql developer you were using?

@sanjaynagpal4423 6 лет назад

sorry it is 4.2 ...please ignore the question

@durgaprasadsriramoji5111 4 года назад

@UCfvRtqeHhbvfhlqB9L1GzUw Hi Sir, After the migration I am unable to connect to the shema with sqlserverdb name as a user and pwd, I also found that there's no such user/schema got created, pls help.

@SubhroneelGanguly 4 года назад

It is not possible to guess what you did during migration. As schema user need to be mentioned by you only.

@prasad014343 4 года назад

@@SubhroneelGanguly you mentioned that you need to connect to Oracle keeping un/pwd as source db name (sqlserver) to be able to see the objects migrated rt,I couldn't find a user created with that name in my case I am telling, I followed the same way u did the migration.