Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL SERVER - VB

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-18 : 09:20:21
Zakir writes "Dear Sir,

I am a software developer. I am facing one problem in vb interacting with sql server.

I wanted to create a database in sql server from vb with same tables and record in the same user. i tried and and reached to a point that i can create database but the problem is how to copy all the tables with records or import all the table from sourse to destination.

I would be greateful to u if u can provide me code and explanation.

waiting for your response.

Zakir"

nr
SQLTeam MVY

12543 Posts

Posted - 2001-12-18 : 10:13:06
You could do this with sql-dmo.
But maybe it would be better to have a backup of the database and just do a restore.



==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -