Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two data locations, one to a local and one to a remote database. How do I copy the local database schema to the remote?

The reason I don't use "Publish to provider" is that I'm not sure that I have all the information necessary to do so. I have the database name, server, username and pass but not "web service address" nor "web service password". I work in Visual Studio 2005. The server is a MSSQL 2005 server. I have tried using the queries but I only get errors doing so.

share|improve this question

Publishing to provider does not mean that you publish the database directly from the local SQL server. What the tool does is generate a series of scripts that script out the scheme and inserts for the actual data. Since you have tried the queries and have gotten errors, you might want to focus on what those errors are and determine why you are getting those and once you find out why, you should then be able to run your scripts to move your database.

Hope this helps some.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.