I want to make new copy of sql old database by VB codding at run time. How is it possible ? Pls guide me. By selfrely7
Best Answer
If you know how to connect to a database in VB and run queries against it, you could connect to two separate databases, perform a query against the old one and the new one. The query on the old one would be selecting data, the query on the new one inserting it. You'd have to copy tables and fields first though. Seems like far more trouble than it's worth. Why not just do a full backup of the database in question and then a full restore at the new location? Other Answer