setup_enterprise.ps1 not updated to use new database files

[skillsinc-Ed]

🐛 Bug Report

Powershell install script is calling out the old database filenames and there is no error checking to see if the files exist before or after the copy command.

Currently is

# Copy database files to user directory
New-Item -ItemType directory -Path C:\CSETDatabase -Force
Copy-Item -Path database\CSETWeb12024.mdf -Destination C:\CSETDatabase\CSETWeb.mdf -Force
Copy-Item -Path database\CSETWeb12024_log.ldf -Destination C:\CSETDatabase\CSETWeb_log.ldf -Force

Should be

# Copy database files to user directory
New-Item -ItemType directory -Path C:\CSETDatabase -Force
Copy-Item -Path database\CSETWeb12120.mdf -Destination C:\CSETDatabase\CSETWeb.mdf -Force
Copy-Item -Path database\CSETWeb12120_log.ldf -Destination C:\CSETDatabase\CSETWeb_log.ldf -Force

[Marcus-Goectau]

Thanks for catching this. Perhaps a better solution would be for us to allow for passing in the database version via command line arguments and avoid hardcoding that into the script. I will make sure to add a work ticket to get this updated.

[martbillinl]

A ticket has been created and we will be looking into this issue.

[adamz01h]

I changed the script to this to just copy whatever database was there and it works as expected.

# Copy database files to user directory
New-Item -ItemType directory -Path C:\CSETDatabase -Force
Copy-Item -Path database\CSETWeb*.mdf -Destination C:\CSETDatabase\CSETWeb.mdf -Force
Copy-Item -Path database\CSETWeb*_log.ldf -Destination C:\CSETDatabase\CSETWeb_log.ldf -Force