Hello! This is a fantastic project you've built. I'm writing to report an issue I encountered while trying to run the code to create the database.
Description:
The main problem is that the required stored procedure for "exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 0" is missing, causing the execution script to fail.
Error Context:
The batch script fails because the referenced stored procedure create_tables_based_on_multiple_definitions does not exist in the %etl_db_name% database.
Affected Script Code:
for /F %%d in ('dir /b /A:D %process_folder%') do (
if exist %process_folder%%%d\create_tables.sql (
echo %db_name% - %%d - get table information
sqlcmd -S %server% -d %db_name% -E -m 1 -i"%process_folder%%%d\create_tables.sql" -o "%sql_log_folder%\unify_get_table_information_create_tables_%%d.log"
sqlcmd -S %server% -d %db_name% -E -m 1 -Q"exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 0" -o "%sql_log_folder%\unify_get_table_information_%%d.log"
) else (
echo No create_tables.sql found in %process_folder%%%d !
)
)
echo %db_name% - create unified tables
sqlcmd -S %server% -d %db_name% -E -m 1 -Q"exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 1" -o "%sql_log_folder%\unify_create_tables.log"
Request:
Could you please provide the complete stored procedure script for create_tables_based_on_multiple_definitions that should be located in the %etl_db_name% database.
Please inform me if alternative methods are available.
Thanks.
Hello! This is a fantastic project you've built. I'm writing to report an issue I encountered while trying to run the code to create the database.
Description:
The main problem is that the required stored procedure for "exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 0" is missing, causing the execution script to fail.
Error Context:
The batch script fails because the referenced stored procedure create_tables_based_on_multiple_definitions does not exist in the %etl_db_name% database.
Affected Script Code:
for /F %%d in ('dir /b /A:D %process_folder%') do (
if exist %process_folder%%%d\create_tables.sql (
echo %db_name% - %%d - get table information
sqlcmd -S %server% -d %db_name% -E -m 1 -i"%process_folder%%%d\create_tables.sql" -o "%sql_log_folder%\unify_get_table_information_create_tables_%%d.log"
sqlcmd -S %server% -d %db_name% -E -m 1 -Q"exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 0" -o "%sql_log_folder%\unify_get_table_information_%%d.log"
) else (
echo No create_tables.sql found in %process_folder%%%d !
)
)
echo %db_name% - create unified tables
sqlcmd -S %server% -d %db_name% -E -m 1 -Q"exec %etl_db_name%.dbo.create_tables_based_on_multiple_definitions '%db_name%', 1" -o "%sql_log_folder%\unify_create_tables.log"
Request:
Could you please provide the complete stored procedure script for create_tables_based_on_multiple_definitions that should be located in the %etl_db_name% database.
Please inform me if alternative methods are available.
Thanks.