October 2, 2018 at 10:10 pm
Hi All,
I'm working for a short while to get all the databases in this agency up to 2017 and prepped for azure or AWS.
I've inherited the current environment which has largely migrated from Oracle to MSSQL 2012/14.
needless to say I have inherited these databases and instances.
The DB Migration tool from Microsoft constantly reports errors regarding the SSMA functions/procedures etc. and they are no longer needed so I'm investigating a way to remove the objects and schema from the databases.
The official Microsoft line is to uninstall the SSMA for oracle, however this leaves the objects in the individual DB's.
There is no documentation or legacy information regarding the migration from Oracle to MSSQL, this was completed by the developer team.
I am looking for an automated solution because there are 20-50 objects across about 8 SQL instances and up to 20 Databases per instance.
Thanks in advance.
October 3, 2018 at 11:36 am
I suggest using Registered Servers in SSMS and registering all your SQL Servers under a Server Group then right click the group and select new query. In the new query write a script using sp_msforeachdb to remove the objects from all your database.
October 4, 2018 at 10:20 pm
Thanks that is cool I didn't realise that was a feature of registered servers.
I'm still after a proper way to drop functions, assemblies, user defined types, scalar value functions and stored procedures if they belong to a schema
I've started writing a script but I'm not really confident
October 5, 2018 at 7:53 am
This was removed by the editor as SPAM
October 5, 2018 at 2:24 pm
Test on a test or development server before deployment.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply