How do I get an SQL file to run?
by 
Egao No Genki
ANSWERS: 1
-
1) "Normally an .sql file is just a text file with a lot of sql statements to be executed. So if you run it with notepad you can see the text. If you need to run the sql statements in Access, there probably is some kind of sql editor in access where you can copy paste the statements and execute them. Beware though that it might not be possible to execute mysql statements on the access database without problems, since there could be some differences in the syntax." Source: http://quomon.com/question_Opening_file_sql_extension_989.aspx 2) In fact, this applies to various databases. Just open the SQL file with an editor, and copypaste it inside the program used inside your database interface to execute SQL commands. Beware that there could be some differences in the syntax for different databases, although they would basically work with SQL, so some converting work would be necessary. Some database enviromments also install a programm which opens and execute files with the extension ".SQL".
iwnit RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC