<div>
You can use SQLDMO to transfer a database from one server to another. &nbsp;Scroll down to the Sql Transfer samples<br />
<br />
<a href="http://www.sqldev.net/sqldmo/SamplesVB6.htm" rel="ugc">http://www.sqldev.net/sqldmo/SamplesVB6.htm</a>
</div>


You can use SQLDMO to transfer a database from one server to another.  Scroll down to the Sql Transfer samples

http://www.sqldev.net/sqldmo/SamplesVB6.htm [http://www.sqldev.net/sqldmo/SamplesVB6.htm]

<div>
Also please have a look at <br />
<a href="http://support.microsoft.com/kb/108147" rel="ugc nofollow">http://support.microsoft.com/kb/108147</a><br />
<a href="https://www.experts-exchange.com/questions/20968600/Copy-table-data-from-one-db-to-another-on-same-server.html" rel="ugc">https://www.experts-exchange.com/questions/20968600/Copy-table-data-from-one-db-to-another-on-same-server.html</a>
</div>


Also please have a look at
http://support.microsoft.com/kb/108147 [http://support.microsoft.com/kb/108147]
https://www.experts-exchange.com/questions/20968600/Copy-table-data-from-one-db-to-another-on-same-server.html [https://www.experts-exchange.com/questions/20968600/Copy-table-data-from-one-db-to-another-on-same-server.html]

<div>
<div class="content wysiwyg-content">
Hi there,<br />
As the title implies I want a VB 6.0 code that copy a SQL Server DB to another SQL Server DB with the whole data in the database including the structure of the tables 
</div>
</div>


Hi there,
As the title implies I want a VB 6.0 code that copy a SQL Server DB to another SQL Server DB with the whole data in the database including the structure of the tables 

VB Code that Copy ALL DataBase Structure and Data From SQLServer 2000 DB  To another SQLServer2000 DB

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.