Recently Amazon Cloud started RDS for Microsoft SQL Server and currently support Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012. Since RDS currently doesn't support restoring database from Backup it is really tedious job to import large database. AWS has detail documentation of export/import database with different method. As mention in documentation Bulk Copy is fastest method when you have big size database. Although everything mention in documentation I will walk you through my experience for importing database.
Point to Remember:
Below are steps to exporting database using bulk copy method from local server and importing to RDS.
select 'bcp [databasename].[dbo].[' + [name] + '] out C:\backup\[dbo].[' + [name] + '].dat -n -S localhost,1433 -U username -P password' from sys.objects where type='U'order by name
select 'bcp [rds-databasename].[dbo].[' + [name] + '] in C:\backup\[dbo].[' + [name] + '].dat -n -S aws-servername,1433 -U username -P password -b 10000 -E' from sys.objects where type='U'order by name
Reference Link
Step mention above is all about what I have experience during importing database. I will appreciate all kind of comment on it.
UPDATE:
I forgot step for creating foreign key/trigger skipped in step 4.
This will required some manual effort. You can use regenerate script feature with enabling foreign key and trigger script enable but you have to keep selected Table Create script to true otherwise script will not generated.
Foreign key script will be at bottom so it will be easy to copy and paste to different file but for trigger you need to manually search and find to separate out.
Another way to do this is use third party software for schema comparision. If you are using SQL Server 2012 or higher below link will be useful for schema comparision as well as data comparision which you may want to do on next step.
http://blogs.msdn.com/b/ssdt/archive/2013/06/24/announcing-sql-server-data-tools-june-2013.aspx