Re: Copy db to webhost server

Thanks for the link, I'll submit a report.
In the meantime, I think I can use MyGeneration to automatically create
correct and complete copy scripts.

Erland Sommarskog wrote:
Indeed, if the SMO method of the Copy Database Wizard permitted you
to specify an existing database that was assumed to be empty, your web
host could create the database, and CDW do the rest. (Well, it may
not be that simple. CDW runs an agent job, on the receiving side,
so you need permissions for this.)

You could submit a suggestion for this on
http://connect.microsoft.com/feedback/default.aspx?SiteID=68. There
are plenty of issues submitted about CDW already, but I don't recall
if anyone has made this suggestion.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Select command with multiple tables
    ... there are about 40 DBASE tables each of which contains fields ... This software will connect to SQL server and retrieve the ... Now my dillema is that should I just create a database containing all ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Getting proper error message at compile time if a table doesn
    ... "Erland Sommarskog" wrote: ... >> doesn't exist in my database, but I can successfully create the stored ... >> I am running large scripts and I must get proper error message at compile ... > have SQL Server to check for all columns. ...
    (microsoft.public.sqlserver.programming)
  • Re: Grant v Deny
    ... "Erland Sommarskog" wrote in message ... Read access to all of the other tables within this database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Grant v Deny
    ... "Erland Sommarskog" wrote in message ... Read access to all of the other tables within this database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Best way to move datafile from C drive to D
    ... restore using the backup over the new version, ... You don't have to create the database prior to restoring it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
Loading