Sunday, June 18, 2023

Re: Can any one help me with this question

Thank you very much praveen, I will try and let you know. 

Annadatja




On Sun, Jun 18, 2023, 9:19 PM Praveen Chaudhary <prabinchy1234@gmail.com> wrote:

Yes, Django migrations can work with Oracle 11.2 using the python-oracle database driver. However, it's important to note that the python-oracle package is not an official Oracle-provided driver. The official driver is called cx_Oracle, which is widely used for connecting Django to Oracle databases.

Here's an example of how Django migrations can work with Oracle 11.2 using cx_Oracle:

1. Install the cx_Oracle package using pip:
     pip install cx_Oracle
2.Update your Django project's settings.py file to include the Oracle database configuration:
     DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.oracle',
        'NAME': 'your_database_name',
        'USER': 'your_username',
        'PASSWORD': 'your_password',
        'HOST': 'your_host',
        'PORT': 'your_port',
    }
}

Replace the 'your_database_name', 'your_username', 'your_password', 'your_host', and 'your_port' with the appropriate values for your Oracle database.

3.Define your Django models in the models.py file.
4.Generate and apply the migrations using Django's makemigrations and migrate commands:

These commands will generate the necessary SQL statements based on your models and apply them to the Oracle database.

Please note that the example assumes you have already set up Oracle 11.2 and have the necessary Oracle client software installed on your machine.

It's also important to ensure that your version of Django is compatible with Oracle 11.2. Refer to the Django documentation and the documentation of the cx_Oracle package for any specific requirements or considerations when working with Oracle databases.

Remember to replace 'your_database_name', 'your_username', 'your_password', 'your_host', and 'your_port' with the appropriate values for your Oracle database configuration.

Prabin Chaudhary
+977-9840193890
Software Engineer | Youth Innovation Lab


On Sun, 18 Jun 2023 at 21:15, Annadatha Rao <annadatha.rao@gmail.com> wrote:
Dear All,

Do DJANGO migrations work with Oracle 11.2 with python-oracle db driver, please show me an example if works.

Thank you for your support,
Annadatha.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFtPNJw9wQgAo2jCFEs6undCf9FZ_oqww9kZWKLLaJAMGyoNaA%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAN9B8Z3itg0bvV8wzoNoAkJiF9FVZ%3DAP2Z2aLxRreYxVVki1_w%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFtPNJzEptw-pUkaDnkfzdew4%2BMicfibfCx4e10rCpZNZ%3D%2BYXw%40mail.gmail.com.

No comments:

Post a Comment