Importing Adventureworks to AWS RDS

Question

Importing Adventureworks to AWS RDS

harry827

SSC Enthusiast

Points: 196
More actions
March 19, 2016 at 11:09 am

#325992

Hi All
New to SQL server and trying to import AdventureWorks sample DB to AWS RDS. Any ideas?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

helper_10 SSC Enthusiast Points: 130 More actions · Answer 1

There are couple of ways to do that; First you can download AdventureWorks Database file with .Bak extension and use restore method to restore to your Management Studio. Secondly, you can attach AWD to your management studio. For the first method make sure the file has .bak extension. If problem persist please let me know.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

helper_10 (3/19/2016)
There are couple of ways to do that; First you can download AdventureWorks Database file with .Bak extension and use restore method to restore to your Management Studio. Secondly, you can attach AWD to your management studio. For the first method make sure the file has .bak extension. If problem persist please let me know.

Are you sure you've done these things with Amazon RDS? That's what the question is about. From what I can tell, it doesn't support SQL Server backups (which can have any extension at all, not just .BAK, try it out). I'm also pretty sure RDS doesn't support attaching an MDF file.

I only have limited experience with RDS. Doing some searches, there are some mechanisms to get you going. Migrating to Amazon RDS. Another migration post.[/url] Using a "restore" operation (actually, just another migration post) to get to RDS.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

BLOB EATER SSChampion Points: 14609 More actions · Answer 3

I have seen the following used on AWS ( importing data to it )

1) SQL Database Migration Wizard ( NOT designed for AWS but I have seen it work )

2) Import / Export Wizard from On Prem

3) BCP utility

The techniques are just not as rich as moving to Azure.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 4

And, worth mentioning, Redgate tools can connect to Amazon RDS. I don't know the full level of support there, but the fundamentals work. So you could use our tools to migrate a database over.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

harry827 SSC Enthusiast Points: 196 More actions · Answer 5

Thanks. Will look at redgate and provide feedback. Regards