CODEWITHSUNDEEP
sql-serverdatabasebackuprestore
Hilmi
Hilmi

Reputation: 3441

Restore to remote database from my local machine

I am registered at Go Daddy and want to restore the database there from my local machine. The tool they provide me with doesn't work unless it's from them. I'm trying to restore from my local SQL server, but when I browse I can't restore the local files of the remote database.

Upvotes: 0

Views: 982

Answers (2)

Pankaj
Pankaj

Reputation: 10115

There are basically two ways to restored the Database using Sql Server.

  1. Through SSMS Restore Utility.
  2. Manual Database restore Script from here

Upvotes: 0

Mr. TA
Mr. TA

Reputation: 5359

They're intentionally preventing users from restoring backups that are "foreign" to them in order to satisfy an obscure Microsoft security recommendation.

You will have to perform a schema comparison and a data comparison between your local machine and the empty database on the hosting to generate the scripts to re-create all of the objects and data. (Having those scripts available in a source control storage would also be helpful.)

Upvotes: 1

Related Questions