I am attempting to copy about 5GB of reference data from a local SQL Server 2008 standard instance to a SQL Server 2008 Express instance on Amazon RDS. (This is a once off import)
Amazon recommend using Bulk Copy for anything larger than ~ 1GB. I have found examples for using bulk copy to copy single tables but not for copying all tables in a database.
Google gives me the following http://support.microsoft.com/kb/176818 but its a bit outdated.
My current plan is to update the above script to do what I need, but wondering if anybody has a better idea.
I often use the SQL Azure Migration Wizard for quick imports - not sure how long a load this size would take, but the tool is super-easy to use. Get it from CodePlex and here's a short screencast on how to use this free tool to do this.