Hi Emmanuel, it is not simple a backup/restore function, what you are asking for? If yes, I think here is a lot of solutions ready-made. Basically, you wan to backup from one machine and restore (re-create) the database on another machine, it's?
On Thu, 04 Sep 2008 21:49:36 +0700, Jeremy Grand <[EMAIL PROTECTED]> wrote: > Emmanuel, I find the following in sql 2k5 books online when I search for > "attach. In other words, there are stored procs and t-sql commands > available that seem to do the things you want. > > > 3Attach the copied files to the instance of SQL Server 2005 by using the > CREATE DATABASE statement with the FOR ATTACH or FOR ATTACH_REBUILD_LOG > option. > > 5. Optionally, if you are making a copy of the database (instead of > moving it), you can reattach the original database on the instance of > SQL Server 7.0 or SQL Server 2000 by using the sp_attach_db or > sp_attach_single_file_db stored procedure. > > > > From: advanced_delphi@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Lamy > Sent: Wednesday, September 03, 2008 9:16 PM > To: advanced_delphi@yahoogroups.com > Subject: [advanced_delphi] Re: AttachDatabase method equivalent in > Delphi > > > 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 > <mailto:advanced_delphi%40yahoogroups.com> , "Vo Viet Anh" > <[EMAIL PROTECTED]> 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/ >> > > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
