Help MS SQL Database Migration

I have an ecommerce MS SQL database on another hosting site that I'm thinking of moving over to Discountasp,,,, it's not that large, but I'm not 100% sure how to bring it over to another hosting company as I don't want to have down time,,,,
It's a small web site with ecommerce ms sql db,,,,

thoughts on how to do this as I'm not a big backend guy,,,,,

thanks

 

You could do it with a minimal amount of downtime, but it would be difficult to do with zero downtime.

Here's how I would approach it if I had to make the move:

1. Open new account here, add a database
2. Copy the site files, etc. to the new account here
3. Suspend the old site long enough to:
   • Transfer the existing schema/data to the database here
   • Change your connection string on the old account to use the database here
4. Restart your site at the old host
5. Make sure the rest of the site is working properly here (using the temporary URL)
6. Change the domain's name servers to point to us

That way any user data input from the old site goes to the database here, and while DNS is updating (and both sites are temporarily available) all the data goes to one database.

Someone else may have another method, but that seems like it might be the easiest way to go about it without taking an extended outage.