There are 6 item(s) tagged with the keyword "SQL".
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.
I was just working around to get list zip code within 25 miles of radius for given address. I have database table for Zip Codes with below columns.
I have created MS SQL function which returns sql table object with list of all zip codes within specified radius in which you might interested.