SQL IN WYUPDATE

Hai,

Am already use WyBuild,WyUpdate,& Automatic Updater in VB.NET application, Now i want to update the sql queries for automatically. how to use sql queries update in WyUpdate?.

thanks

See: Updating databases (Microsoft SQL Server, MySQL, etc.)

Am using the WyUpdate in sql..

I give the values for Command Line Switches: --folder="%E%\Database" --oldvars="%versionfrom%"

how to give the values for Command Line Switches

please tell

I don't understand. What are you doing now and what are you trying to do?

Now am using ,

Updating databases (Microsoft SQL Server, MySQL,) -this type used

1)Add the *.bat files to the "Temporary folder" in wyBuild.2)Select the *.bat file and click "Execute file", select "After updating has finished", and check "Wait for execution to finish before continuing".This two step after what i do to update the script in database?

You need to write the actual SQL script to update your databases, tables, rows, etc. wyBuild isn't magic (not yet, at least). It doesn't know what you want to put in your database. You have to tell it.

By "tell it" I mean write the SQL script, and write the batch file that will use the appropriate sql tool for updating your database.

How to create the *. bat file that will call the command line tool for our database

A *.bat file is just a text file with a "bat" extension instead of a "txt" extension. For example, create a text file named "update_database.txt", then change "txt" to "bat".

What do you put in a *.bat file? Simple, anything you would've typed in the "console" windows (cmd.exe). Google for more information about using batch files.

Reply
Discard post