Re: Can any one help me with this question

Hi  Prabin,

Thank you, it worked when I upgraded db to 21c (oracle), thank you for your help. Small question, can I work without migrations, some have I hate migrations being a legacy programmer from (Cobol days). I value your opinion.

Thank you,

ANNADATHA.

On Sun, Jun 18, 2023 at 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

https://www.linkedin.com/in/icedreamerpraveen/

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/CAFtPNJwWEh%2BrqVMLemRdMi0__UGp2ZJg-%2B6Ee2K-U%2B8VJvgKcw%40mail.gmail.com.