Slide 1
Most trusted JOB oriented professional program
DevOps Certified Professional (DCP)

Take your first step into the world of DevOps with this course, which will help you to learn about the methodologies and tools used to develop, deploy, and operate high-quality software.

Slide 2
DevOps to DevSecOps – Learn the evolution
DevSecOps Certified Professional (DSOCP)

Learn to automate security into a fast-paced DevOps environment using various open-source tools and scripts.

Slide 2
Get certified in the new tech skill to rule the industry
Site Reliability Engineering (SRE) Certified Professional

A method of measuring and achieving reliability through engineering and operations work – developed by Google to manage services.

Slide 2
Master the art of DevOps
Master in DevOps Engineering (MDE)

Get enrolled for the most advanced and only course in the WORLD which can make you an expert and proficient Architect in DevOps, DevSecOps and Site Reliability Engineering (SRE) principles together.

Slide 2
Gain expertise and certified yourself
Azure DevOps Solutions Expert

Learn about the DevOps services available on Azure and how you can use them to make your workflow more efficient.

Slide 3
Learn and get certified
AWS Certified DevOps Professional

Learn about the DevOps services offered by AWS and how you can use them to make your workflow more efficient.

previous arrow
next arrow

Compile sql file for syntax for error

Spread the Knowledge

saiki created the topic: Compile sql file for syntax for error
Hi,

How to Compile sql file for syntax error using ANT script.

Is there any possibility to compile through batch file.

I have 100 of sql file i dont want to create db and know the error in file.

Like java i want to compile it

rajeshkumar replied the topic: Re: Compile sql file for syntax for error
One way – exec method where you can mysqld and do whatever you want.
ant.apache.org/manual/Tasks/exec.html

Another way
www.roseindia.net/tutorials/ant/AntScriptCreateMysqlTable.shtml

Please try any of these and let me if you have any issues in script.
Regards,
Rajesh Kumar
Twitt me @ twitter.com/RajeshKumarIn

saiki replied the topic: Re: Compile sql file for syntax for error
Currently we are creating database through ant script only from CI. We do this build for every 8hrs.

Problem is b4 running the build we are deleting the existing database and then creating the new DB with same name. If there are any syntax error in the sql file the build fails and then it takes some time to fix it.

Idea is to compile sql (Check for syntax error) file for every 3hrs rather than executing and creating new DB and data ?

Rajesh Kumar