I try to import / execute this file to SSMS 2012.
Ι have download and export the zip file and I have a .sql file of around 700MB.
I went to File --> Open --> File and selected the file but it is not working.
How can I import it?
Asked
Active
Viewed 2,186 times
-1
marc_s
- 732,580
- 175
- 1,330
- 1,459
user3456789
- 3
- 1
- 6
-
1How is it not working? What happens when you do the file > open? – Tab Alleman Feb 10 '15 at 18:43
-
@TabAlleman Exception of type 'System.OutOfMemoryException' was thrown – user3456789 Feb 10 '15 at 18:49
-
Your computer doesn't have enough free memory to load the whole file into an SSMS window. Close everything you can and try again. – Tab Alleman Feb 10 '15 at 18:50
-
@TabAlleman I made it but again the same. Thank you for your time and your comments – user3456789 Feb 10 '15 at 19:29
1 Answers
1
If the file is too large to open in SSMS then you can execute it using sqlcmd.
https://msdn.microsoft.com/en-us/library/ms170572(v=sql.110).aspx
-
sqlcmd -S
-i C:\kickscrape_5-7-13\kickscrape.sql -o I open the cmd command and type the previous but it is not working because it says it could not find the file path in the system – user3456789 Feb 10 '15 at 19:28 -
If it says it can't find the path, then you are not pointing to the correct folder. Check to make sure C:\kickscrape_5-7-13\ is a valid location in your file system and the account running sqlcmd has access to it. – Ben Kean Feb 10 '15 at 19:39
-
I checked it and it is the right path. Should I make something different to the command like
? – user3456789 Feb 13 '15 at 14:03 -
maybe sqlcmd isn't in your path environment variable, try changing to the sql install directory before running the command. `cd C:\Program Files\Microsoft SQL Server\xxx\Tools\Binn' where xxx is your SQL version. For 2012 it's 110 – Ben Kean Feb 13 '15 at 14:29