Recently we realised that across 10 similar databases we have some change in naming conventions with regards upper case and lower case apart from that all the names are same.
Now i want to make them unique across all the databases. I have main database from which i want to make other 9 db's unique to it. What would be the simple way to change all the 9 databases idetical to the main database.