application+database in an independent executable file

[rzamith]

Hi!
I have an application, created through vb.net 2003, with a database registered on SQL Server. I need to format my pc, and I'm afraid that I cannot entirely backup my database, for an afterwards importing.

Can someone explain me how to create an exe that includes application+database, or at least something that excludes using sql server (considering that the database with no longer be updated!).

Hope I've made my self clear.

All the best!
RZ

[jmcilhinney]

How could a backup on SQL Server not backup the entire database? Businesses use SQL Server to store critical data. Do you think that they would use it if their backups only stored some of the data. Just backup your database, format your system, then restore your database. It will all be there. If you're not convinced then you should definitely do what you should be doing anyway: restore the database immediately after backing it up to see that it contains all the schema and data. You'll find that it will.

[rzamith]

Well, that's what I did.. but probably didn't perform it well! I tried to backup and restore some time ago, and for example the database stored procedures were lost. I perhaps did something wrong.

Anyway, do you know of any software to convert the database+program to an unique file? I don't really need to edit the database or vb.net codes any more.

Thanks for your help mate!
Rui