Copy Other Database SQL Server with VB or VB.Net

Question

Hello, who can help me... How coding in VB.Net with SQL Server, I want to copy all table in other Database SQL Server to the current Database SQL Server ? Examples : A Company have a branch office and this company using same Aplication and Database (SQL Server), and then in the Central Office want merger or copy database from Branch Office. Thank's