sql-serverssmssqlcmdssms-2012
SQLCMD to import large sql file gives "Invalid object name" error
I am trying to import a large .SQL file (downloaded here) (210mb) containing postcodes in a table called postcodelatlng. This is the setup:
I tried executing the query directly in SSMS 2012 but it's complains about the lack of memory.
Further reading, pointed me use command tools using SQLCMD, where I tried:
C:\Windows\system32>sqlcmd -S (LocalDB)\v11.0 -i D:\Ben\Desktop\ukpostcodesmssql_1.sql
But this throws me this error:
Msg 208, Level 16, State 1, Server BEN-PC\LOCALDB#850F4379, Line 1 Invalid object name 'postcodelatlng'.
Which I guess it's just not reaching that table correctly. I'm sure it's probably a rookie mistake but I haven't been able to solve it.
Solution
The .SQL file is plain text. Open it using a text editor (I recommend NotePad++) and then copy & paste the commands into SSMS partially and execute incrementally until you have all of the records loaded.
- SSRS Query execution failed for dataset
- Insert leading spaces, then the value to a varchar(10) column
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- No PK or FK when exporting SQL Server database
- SQL Server SELECT LAST N Rows
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- Union two selects removing duplicates base on some columns (not the full row)
- SQL fill gaps with hold
- Create login and logout rows from single row
- Create Index without name while creating table
- Extracting SQL Server table data to parquet file
- SQL, How to convert VARCHAR to bigint?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- SQL Server query to find all permissions/access for all users in a database
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- inserting data into SQL DB from C# ASP.NET
- Display the average number of days between a customer's last and second to the last transaction
- Fastest way to determine if record exists
- Unrecognized column name that I define
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?