Post reply

Importing Adventureworks to AWS RDS

  • 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

  • March 19, 2016 at 11:18 pm

    #1866302

    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.

  • March 21, 2016 at 6:28 am

    #1866420

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • March 21, 2016 at 6:52 am

    #1866433

    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.

  • March 21, 2016 at 7:20 am

    #1866439

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • March 21, 2016 at 7:24 am

    #1866442

    Thanks. Will look at redgate and provide feedback. Regards

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

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