Generating rows for each day of a conference

mym

Hello,
I have two tables: conference and conference_day.

conference
--------------
conference_id PK
start_date
number_of_days
capacity

conference_day
--------------------
conference_day_id PK
conference_id FK
date
capacity

I have a problem with generating data to conference_day table. For each conference I need to have every conference day generated starting from conference.start_date to (conference.start_date + conference_number_of_days). What's more  conference_day.capacity must be the same as conferece.capacity. 
Could you pleace help me with this problem?
Thank you in advance. 

sam.blackburn

Yes, you can do it using Python.  Here are some example scripts to solve similar sorts of problems:

https://documentation.red-gate.com/display/SDG4/Example+Python+scripts