Our drive where all of our database files are stored is full and cannot be expanded so we are planning to move all of the database files to a new drive. We already know how to re-point the database to the correct file in Management Studio but are unsure on how SSRS and SSIS will react to this change. Will we need to redeploy all of the reports and packages or will they continue to work once the databases are working correctly? Any articles and/or proof found on this are welcome. I tried finding this on Google but just kept finding the same stuff on how to move the mdf file.
Database pathing is completely transparent to client applications. If the databases remain on the same instance, this will have no impact on SSRS or SSIS unless the SSIS package is creating, detaching, attaching or restoring a database or file/filegroup to a particular path.