OK i have this app i want to distribute that uses an SQL Server DB. THe users already have SQL Server on thier machine. Once this app is installed on the users machine how i do create a DB in the SQL server?
Thanks!:D
Printable View
OK i have this app i want to distribute that uses an SQL Server DB. THe users already have SQL Server on thier machine. Once this app is installed on the users machine how i do create a DB in the SQL server?
Thanks!:D
Neeeed help. Thanks! :D
Create the database locally and then use enterprise manager to generate the script in one file for creating the database and all objects.
Then distribute this script with your exe and in the installation use a program that comes with SQL Server called ISQL to run the script.
Usually : -
C:\MSSQL7\BINN\ISQL.exe -i <script name>
Hope that helps.