to create exe for sql

Question

to create exe for sql

abhithakur7

SSC Veteran

Points: 285
More actions
July 8, 2008 at 8:08 am

#190248

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

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..

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 2

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.

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 3

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

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 4

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

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 5

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

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]