July 8, 2008 at 8:08 am
H! all,
I m totally NewB in SQL (which can be understood from my question also.......)
currently, i m working on VB in which data is accessd from SQL database.....In DB, i have created some tables manualy.....Now, suppose i want to run my application on other machine, i need same tables on that machine.....so how to create tables there with any EXE...
Hope, some exepert have got my problem and will answer ealiest
ABHI-NewB
July 8, 2008 at 8:18 am
You can script your tables from SQL management studio, right click on the database and click create to. then run this script on your other database.
But the point of SQL server is that it is meant to be run in a server environment, are both your computers on the same network ?, if so they should really access the same database..
July 22, 2008 at 3:04 am
abhithakur7 (7/8/2008)
H! all,I m totally NewB in SQL (which can be understood from my question also.......)
currently, i m working on VB in which data is accessd from SQL database.....In DB, i have created some tables manualy.....Now, suppose i want to run my application on other machine, i need same tables on that machine.....so how to create tables there with any EXE...
Hope, some exepert have got my problem and will answer ealiest
ABHI-NewB
Think you may not be able to create any exe in
SQL Server as in VB, as pointed out you have to script the tables and then run them in the new database on the new server.
July 22, 2008 at 9:03 am
Hi,
Instead of deploying your tables, why canot you share the database?
Other option is export the table structures in .sql file and run this file.
Thanks -- Vj
July 30, 2008 at 5:22 am
As far as I understood your question, you are trying to create some tables through your VB application at runtime. For example on Clicking the commandbutton1, Table1 created on the Server.
Ya... Its possible. Use Connection.execute("Create Table...") Command.
i hope it will work.
Atif Sheikh
July 30, 2008 at 5:23 am
But the best is that you should create a script file, as suggested above for the tables that you want on the new machine.
Atif Sheikh
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply