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)
 Create Database and tables on Remote Server

Author  Topic 

kamalkishore_in
Yak Posting Veteran

76 Posts

Posted - 2001-11-14 : 00:54:05
Hello,

I have to create a databse on the remote server and to copy all the tables (only structure) to the remote server from local server.

I am using VB 6 and SQL 2000.

I have a .sql file generrated with Generate SQL option from SQL server, which has queries to create the structure of all the tables.

Can I execute a .sql file using VB Connection string to the remote server.

or What is the convient way or what are the options availble for that.

I need some suggesstions to fullfill this task.





   

- Advertisement -