Hi,
Trying to look at exporting (using bcp) certain tables of a SQL database, dropping the previously installed database, restoring the database (updated as part of the Installer script) and then importing the already backed up tables again using bcp.
I.e. need to keep data in certain tables that have been updated by the customer but update other tables supplied by me.
I have batch files for the exporting and importing of the tables but trying to figure out where I place the custom actions in the Custom Behaviour | Custom Actions | Install Execution Stage.
Need to put the Custom actions one each side of the SQL Scripting (in Server SQL Databases | Database server)
OR
Do I have to do all this in the Server | SQL Databases | Database Server in the SQL Script tab with other scripting that drops the database and restores it.
Thanks,
Brian