Need To Create "Back Up" Function

[Tyecom]

I have an application that was created in VB.Net 2005, using Windows Forms. The application has a DataGridView that is accessing its data from a SQL Database. One of the function of the application is to allow users to "back up" their SQL scripts to a USB drive. Can anyone help me do this?
Thank you in advance.

 

[Cavar]

If by scripts you mean the SQL that's used to create the objects in the database then you can look into SQL DMO for SQL 2000 and SQL SMO for SQL 2005. These objects allow you to query tables, stored procedures, etc.

I'm currently using these object to generate the schemas for all our client databases on our server and then comparing them to a master set of scripts to make sure nothing gets missed when updating databases.

Hope this helps,
CT

 

[Tyecom]

Yes. It helps a lot, thank you for the information.

Thank you very much for this information. I think I will use your approach.

 

[Cavar]

Thank you very much for this information. I think I will use your approach.

You're welcome.
CT