I had use SQLDMO for "bulk copy" a database. It's easy. It's like DAO through Access (maybe you know it). SQLDMO is the SQL Server's automation object library (like Word.Application)

What do you need? Single, SQL Server installed on your PC (doesn't matter if you're running on a Win9x PC). Add a reference in your VB project to Microsoft SQLDMO Object Library and browse it through Object Browser for to see all its properties and methods. If you think distribute your app, maybe you consider install only on a Windows NT machine or a PC with SQL Server pre-installed.


glurrea