How to execute complete database script without checks on objects existence
0
votes
1
answer
140
views
I'm working on a customer data archiving.
I created a complete database script to prepare the new database for archiving data with the same DB schema of the production one.
At the moment I'm preparing a Test environment to verify all the steps we will execute in in production later, but the script is, obviously, raising a lot of errors because of missing external database's views, functions and stored procedure being referred to.
Is it possible to switch off objects existence during the script execution, so I can create the complete database schema to make my tests?
---
I decided to proceed with tests about restoring the whole production database and then clear all tables data.
To clear the data I will try suggestions I found in replies to this question in Stack Overflow, to be precise these two:
- https://stackoverflow.com/a/12719464/21116580
- https://stackoverflow.com/a/22527902/21116580
I will come back as soon as I'll complete my tests with the results.
Asked by El See
(1 rep)
May 20, 2024, 03:29 PM
Last activity: Aug 3, 2025, 05:05 AM
Last activity: Aug 3, 2025, 05:05 AM