See: Updating databases (Microsoft SQL Server, MySQL, etc.).
Tell me if this helps.
hi sir,
how to create a job step using sql server management studio. give one example snap shop of how to create.it will be helpful to me.....
See: Updating databases (Microsoft SQL Server, MySQL, etc.).
Tell me if this helps.
A bat file is just a text file with a ".bat" extension instead of a ".txt" extension. So create a text file and rename it to have a .bat extension.
Whatever commandline utility you're using to update your database. Search google for more general information on creating batch files.
What database are you using (MySQL, MS SQL, etc.)? Did you use the appropriate commandline utility to update your database? Is your SQL script valid?
Am using ms sql2008 and my scripts are valid script only.still i cant able to get the concept of creating the command line utility after reading the link you gave.so if any video tutorial is there means it will be very helpful to me.
please give if any video tutorial
A video tutorial wouldn't help. It would basically be a bunch of text that wouldn't be able to select -- which is pretty useless.
Since you're using the Microsoft SQL Server, you'll need to use the sqlcmd utility to update your database.
Step 1: Open cmd.exe on your computer.Step 2: Run sqlcmd.exe. Can it be found? If not, try specifying the full path (like %programfiles%\MS SQL\sqlcmd.exe or something like that)Step 3: Read the sqlcmd utility article to learn how to update your database using a simpe SQL script.Step 4: Once you've got the sqlcmd thing all figured out, copy the line you typed into the cmd window and paste that into and emtpy *.bat file. This is the bat file you'll be including in your update.
I don't usually butt into threads... but I just had to say that Sam sure has the patience of a saint.
😀