I have a db called 'mysite_db' on a server and I have created a copy on my local machine which is also 'mysite_db'. I would like to attach the db (from my local machine) to the server which already has this db name. Meaning I have to change my local db's name (I guess I also need to change the physical file). I'm lost with how to do that. Can you please guide me?
My goal is to load the 2 databases on the server for example: 'mysite_db' and 'myNewSite_db'