sql server 2005 - Database Backup -


scenario

I want to back up from 7 client databases in 1 server database. I do not know the structure of DB {Either server or client DB}. Both databases are old data, now I have to back up to make the device and it is also possible to back up the old data [if an old data has been updated.] Please help find the solution for this. 1. How can I proceed with this problem 2. The database is not specified, may be MS Access or SQL Server 2005. 3. In which I can apply it [I am thinking of doing it in C #]

Please help me find solutions

I'm not sure why you want to go this way - if you are trying to copy the customer database (which I call "file based" ), So why not just copy your files as part of the comprehensive backup strategy?

If you want to write backup materials to keep all the data in a server-based RDBMS, you will also have to think about how you can restore that information later - possibly due to its And also coding means you

So - I do not think this is a good idea, but if you are determined, then I will start by writing a class (which will be almost abstract), dedicated client databases (tables, Fields, views, etc.) I get to get a specific class to do this for each person's customer DB when you have one time, then you can call the talc in the client db You can use ADOnate to read the values ​​of audio, create data with the information, and then write back that information back into server-based DB.

Although I really, I do not like this idea - it is very complex, and will not be able to deal with functions etc.

Best wishes anyway,

Martin


Comments