I have a database for my website running on AWS. My web admin has given me access to the database, and I'd like to host and manage it on my own. How do I migrate the SQL database from AWS to my own SQL server?
closed as too broad by mustaccio, LowlyDBA, RLF, Julien Vavasseur, James Anderson Jul 15 '16 at 7:43
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Not sure if you mean the Instance or the database, as your question is referring to both (as if they are one).
If you're speaking of migrating a database from one server/instance to another: If you have access to the .mdb/.mdf files, I'd say copy it over to whichever the destination server is, then run SQL Server's Database Import/Restore functionality.
The option I'd prefer: Using the "Copy Database" functionality, available by Right clicking the database name and selecting Tasks->Copy Database and following the wizard.
After this, you'll be able to use the Import/export data wizard to get the data replicated over.
If you're speaking of migrating an entire instance: Not entirely sure I'd take that approach, as I like to do one database at a time when replicating/migrating. This is because I've often run into issues and it's much easier to isolate when you take it one database at a time.
The database is 17.5mb, so quite small. I am assuming you can RDP onto the server in AWS, or have the ability to RDP? If so, then simply take a backup of the database, copy the backup down to your local machine, and then restore it locally.