Copy database using stored procedure ?

We are using SQL Server 2005.
From my VB.NET program, I would like to call a SQL Server Stored Procedure
to copy the database to another database.
I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
there a COPY DATABASE command ?
Thank you.
Using BACKUP/RESTORE is a good and reliable option. There is no COPY
DATABASE command in T-SQL.
Another option to explore is using SMO (since you are using .NET). Take a
look at the links below:
[url]http://davidhayden.com/blog/dave/archive/2006/11/09/CopyDatabaseSchemaDataSQLServerManagementObjects.a spx[/url]
[url]http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.tasks.transferdatabasetask .transferdatabasetask.aspx[/url]
HTH,
Plamen Ratchev
E-Mail: Plamen@.Ratchev.com
|||fniles wrote:
> We are using SQL Server 2005.
> From my VB.NET program, I would like to call a SQL Server Stored Procedure
> to copy the database to another database.
> I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
> there a COPY DATABASE command ?
> Thank you.
>
>
not heard of such command but you can still simulate COPY with
ATTACH/DETACH functions...
http://support.microsoft.com/kb/224071/
HTH,
Petar Atanasov
http://a-wake.net

Copy database using stored procedure ?

We are using SQL Server 2005.
From my VB.NET program, I would like to call a SQL Server Stored Procedure
to copy the database to another database.
I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
there a COPY DATABASE command ?
Thank you.Using BACKUP/RESTORE is a good and reliable option. There is no COPY
DATABASE command in T-SQL.
Another option to explore is using SMO (since you are using .NET). Take a
look at the links below:
http://davidhayden.com/blog/dave/archive/2006/11/09/CopyDatabaseSchemaDataSQLServerManagementObjects.aspx
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.tasks.transferdatabasetask.transferdatabasetask.aspx
HTH,
Plamen Ratchev
E-Mail: Plamen@.Ratchev.com|||fniles wrote:
> We are using SQL Server 2005.
> From my VB.NET program, I would like to call a SQL Server Stored Procedure
> to copy the database to another database.
> I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
> there a COPY DATABASE command ?
> Thank you.
>
>
not heard of such command but you can still simulate COPY with
ATTACH/DETACH functions...
http://support.microsoft.com/kb/224071/
HTH,
Petar Atanasov
http://a-wake.net

Copy database using stored procedure ?

We are using SQL Server 2005.
From my VB.NET program, I would like to call a SQL Server Stored Procedure
to copy the database to another database.
I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
there a COPY DATABASE command ?
Thank you.Using BACKUP/RESTORE is a good and reliable option. There is no COPY
DATABASE command in T-SQL.
Another option to explore is using SMO (since you are using .NET). Take a
look at the links below:
http://davidhayden.com/blog/dave/ar...entObjects.aspx
http://msdn2.microsoft.com/en-us/li...tabasetask.aspx
HTH,
Plamen Ratchev
E-Mail: Plamen@.Ratchev.com|||fniles wrote:
> We are using SQL Server 2005.
> From my VB.NET program, I would like to call a SQL Server Stored Procedure
> to copy the database to another database.
> I can do that with Backup (using BACKUP DATABASE T-SQL command), but is
> there a COPY DATABASE command ?
> Thank you.
>
>
not heard of such command but you can still simulate COPY with
ATTACH/DETACH functions...
http://support.microsoft.com/kb/224071/
HTH,
Petar Atanasov
http://a-wake.net

Converting MSDE 7 to SQL2000?

Hi All,
I am trying to upgrade a program that used MSDE 7 but now
migrating to SQL2000. I performed a tables & Views import
from one server to another however the program returns
errors when trying to intall its upgrade:
SQL Error Message from
CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE:
42S01 Native error: 2714 Message: There is already an
object named 'vMDSMap' in the database.
It looks like it has changed the format of the db during
the import. Has anyone successfully migrated from MSDE 7
to SQL2000?
Thanks
The simplest way I'd use is:
1. On the MSDE1.0 (SQL Server7, not MSDE 7) computer, detach the said
database.
2. Copy the *.mdf and *.ldf files to the SQL Server2000 computer.
3. Attach the files to SQL 2000.
"Andreas" <a_kaestel@.connexus.net.au> wrote in message
news:035901c4fa2a$7b9b9220$a501280a@.phx.gbl...
> Hi All,
> I am trying to upgrade a program that used MSDE 7 but now
> migrating to SQL2000. I performed a tables & Views import
> from one server to another however the program returns
> errors when trying to intall its upgrade:
> SQL Error Message from
> CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE:
> 42S01 Native error: 2714 Message: There is already an
> object named 'vMDSMap' in the database.
> It looks like it has changed the format of the db during
> the import. Has anyone successfully migrated from MSDE 7
> to SQL2000?
> Thanks