That option is avaible from within SQL Server Mgr. Just create a backup and
restore it on the new system.
Dave
--- On Wed, 9/3/08, Emmanuel Lamy <[EMAIL PROTECTED]> wrote:
From: Emmanuel Lamy <[EMAIL PROTECTED]>
Subject: [advanced_delphi] Re: AttachDatabase method equivalent in Delphi
To: advanced_delphi@yahoogroups.com
Date: Wednesday, September 3, 2008, 9:16 PM
I am sorry if my question led you to confusion. What I want to
accomplish is to use the data and log files from a SQL database to re-
create the database on another machine, or on another instance of SQL
Server. VB coders have the AttachDatabase method to do just that. My
question was simply if there is a homologous method in delphi to
achieve the same task, or if there is a way around the problem.
Emmanuel
--- In advanced_delphi@ yahoogroups. com, "Vo Viet Anh"
<vietanh1969@ ...> wrote:
>
> Hi Emmanuel,
> The question is quite confusing. Can you please explain it a bit
more in
> details? With "SQL Server" did you might the ADOSQLConnection or
> SQLConnection (in SQL Express) or whatelse?
>
> On Wed, 27 Aug 2008 10:14:50 +0700, Emmanuel Lamy <[EMAIL PROTECTED]>
> wrote:
>
> > Hi everybody,
> >
> > Anyone knows if there is a Delphi method that accomplishes the
same
> > action as the VB "AttachDatabase" method that the VB programer
can use
> > to "attach" an existing database defined by one or several files
to a
> > defined instance of SQL Server? Or better, is there an
alternative as
> > to register an external SQL database file with another instance
of a
> > SQL Server, or SQL Express? Any hint or suggestions welcome. TIA.
> >
> > Emmanuel
> >
> >
>
>
>
> --
> Using Opera's revolutionary e-mail client:
http://www.opera. com/mail/
>
