Setup for VB Application

[gdipankar]

I have a VB Standard Exe application which uses SQL Server 2000 as back-end. How do I prepare a setup which installs/creates the database on another machine which has SQL Server installed ?

[dglienna]

Compile it, and run the Add-In called the Package and Deployement Wizard.

It will guide you through all of the steps required to make an installation program. You may have trouble with dependency files, but seeing that it is a M$ product, then the odds are in your favor that it will install correctly.

[RobDog888]

Welcome to the Forums.

If it is the first time your program runs, it should check for the exisiance of the DB. Then if its not found then
it should create it. Use the "Generate Script" menu item in Enterprise Manager to script out the db. Then
when your app need to create it you can execute the script to create the db, tables, views, udts, and grant
permissions to any users that you create or assign to the db.

HTH

[gdipankar]

Thanks a lot. But where do I find the Enterprise Manager ? In SQL Server 2000 ?

[dglienna]

oops. i don't have sql, so i couldn't help there.

[hyousuf2]

yes offcourse, Enterprise Manager is an SQL Server 2000 application, its nothing but just a MMC console.
ne ways, if ure connecting ur app. to db using a static connection string then u'll have to add the data files to ur setup, but this is not recommended, u should use DSNs

[RobDog888]

You can install EM on any system because its only part of the SQL Client Tools, not the actual SQL Server.
Once you have Enterprize Manager installed you should also have other client tools like SQL Query Analyzer, SQL Profiler,
and SQL Books On-Line (Help file - highly reccommend instaling BOL!).

In EM after you register the SQL Server that is on your Server, you can connect to it and do thinks like you
were on the actual server. This includes generating a DB Script. You can then generate a script for the entire
DB lik eI posted earlier. This can be saved as a text file for use in you DB installation program. You would then
execute the script using ADO, for example, to create the db on the target server. The DB can only be installed
on a Server running SQL Server.

HTH

[dglienna]

and it only comes with SQL Server?

[RobDog888]

and it only comes with SQL Server?

Yes, Enterprise Manager and the Client Tools only come with SQL Server 7.0, 8.0 (2000), and 9.0 (2005).
SQL Server 6.5 has a version of it but it is limited since it was new back then.

[gdipankar]

Thanks a lot for your help.