I have a .sql file over 200 MB how to execute in SQL server

Question

Hi frnds. i took a back up script in MY SQL db and execute that script in SQL Server how to run it.. Thanks in advance.

Abhay Shanker · Answer

Try to execute from command prompt check below link http://stackoverflow.com/questions/431913/how-do-you-run-a-300mb-ms-sql-sql-file Not sure  below link can also be helpful for you http://themetaq.com/articles/uploading-large-sql-files http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

Hanook · Answer

use osql command to run large size scripts http://msdn.microsoft.com/en-us/library/ms162806%28v=sql.100%29.aspx R eferences: http://stackoverflow.com/questions/12592124/run-3-5-gb-sql-file-on-sql-server-2008 http://www.sqlservercentral.com/Forums/Topic853851-149-1.aspx