importing .sql file in SQLServer

Question

please, i want to import database in sql server from .sql file using visual studio 2013. i've tried this command :

source fileLocation\file.sql
go

but i'm getting the error :

erreur is Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '\'.

sql file :

USE [master]
GO
CREATE DATABASE [SomeDatabaseName]
CONTAINMENT = NONE
ON  PRIMARY 
( NAME = 'SomeDatabaseName', FILENAME = N'C:\FilePath\SomeDatabaseName.mdf'  
,SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON 
...

And what do you expect the `source` keyword to do? That is a MySQL command. — Lasse V. Karlsen, Jul 16 '16 at 12:53

score 0 · Accepted Answer · edited May 23 '17 at 11:46

0

solution is here How to import .sql file into SQL Server Express

if is not working open new query and copy content of file.sql in it

edited May 23 '17 at 11:46

Community

1
1

answered Jul 16 '16 at 14:52

infox09

5
4

importing .sql file in SQLServer

1 Answers1