Re: What is the best way to copy a database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Any of the tools to copy databases by reading schema and creating DDL and DML work slow. This is largely from the large amount of lines of code they create. The Database Publishing wizard will create a file rather quickly, but running it for a huge database is a big waste of time. It is great for creating seed database scripts, howvever.

Backup and restore, in general, is the easiest option.
Copy is fine for initial deployment.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message news:pvs9f455gd5rrdiseo0qsi1d9211puet4u@xxxxxxxxxx
Sorry - I was typing fast. The backup/restore approach worked fine.

The Copy Database wizard was a giant time suck that never worked. So I
would suggest avoiding it.

thanks - dave


On Fri, 10 Oct 2008 18:08:59 -0500, "Hillbilly"
<somebody@xxxxxxxxxxxxx> wrote:

Which "it?"

"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message
news:8iive495e7n7c6os887ao790f13o0tp2jr@xxxxxxxxxx
THANK YOU!!!!!!!!!!!!!!

Much easier and unliek COpy Database, it works!!!

thanks - dave


On Thu, 9 Oct 2008 22:30:43 -0500, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote:

Detach file and copy to server.

Other option. Backup database and restore on other server.

Other option. Download the Database Publishing Wizard and do data and
schema
for entire database.


david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm


david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

.

Relevant Pages

  • Re: DbDataReadet.GetOrdinal() - duplicate column name
    ... Cubicle Wars - http://www.windwardreports.com/film.htm ... "Robert Simpson" wrote: ... information on the columninvolved in the active query. ... As a commercial library that is seperate from the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Best way to create a database
    ... So many vendors with so many versions... ... Cubicle Wars - http://www.windwardreports.com/film.htm ... We do require it be a real SQL database (ie not ... Sybase/Microsoft SQL Server, I would not count on them working for Oracle ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Best way to create a database
    ... YOU are the vendor?? ... Cubicle Wars - http://www.windwardreports.com/film.htm ... We do require it be a real SQL database (ie ... and they won't work for JET/Access or SQL Server Everywhere. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Best way to create a database
    ... trying to support so many DB's out there. ... Cubicle Wars - http://www.windwardreports.com/film.htm ... We do require it be a real SQL database (ie not ... Sybase/Microsoft SQL Server, I would not count on them working for Oracle ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Best way to create a database
    ... ASP.NET app to each have their own prefered database. ... it is not going to install SqlServer just because we ask them too. ... Cubicle Wars - http://www.windwardreports.com/film.htm ... and they won't work for JET/Access or SQL Server Everywhere. ...
    (microsoft.public.dotnet.framework.adonet)