all groups > sql server dts > march 2007 >
You're in the

sql server dts

group:

Loading a .bak file with C#?


Loading a .bak file with C#? Derrick
3/14/2007 11:19:05 AM
sql server dts:
Hi All -

I need to load a sql (2000 for now) db back from .NET code, should I still
use the DTS objects to perform this task, or is there something "newer" in
..NET 2.0 that i can leverage?

Thanks in advance!

Derrick

Re: Loading a .bak file with C#? Derrick
3/14/2007 2:32:51 PM
Thanks for the reply. I just found SQL-DMO, think that's what I am looking
for, want to restore and create dbs from code, not fat finger users.


[quoted text, click to view]

Re: Loading a .bak file with C#? Allan Mitchell
3/14/2007 6:13:37 PM
To load a .bak file you would RESTORE the file to SQL Server. To do
that you do not need DTS at all.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



[quoted text, click to view]
Re: Loading a .bak file with C#? Allan Mitchell
3/14/2007 7:04:21 PM
Yep. DMO would be the way to go here.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



[quoted text, click to view]
AddThis Social Bookmark Button