Groups | Blog | Home
all groups > sql server new users > june 2005 >

sql server new users : (SQLExpress) Import .sql file howto ?


MAF
6/20/2005 12:00:00 AM
Hi every body,

I have recently find out we can train ourself on SQL Server thanks to
the Express Edition.

So I'm trying to import a db structure (.sql file) and then fill it with
some data given in another file (.txt)
But I can't find any relevant documentation (a reference guide for
exemple would be nice) on how to do it with the commandline (using
sqlcmd tool I think)

So my questions are the following:
1. where to find REAL documentation (not only the sqlexpress' blog...)
2. how to import a .sql file (in DOS prompt or Grapically)

Thank you !

PS: why with the commandline ? because my db is remote and I don't have
vnc-like access
--
MAF <maf NO albert SPAM com>
Hari Prasad
6/20/2005 12:00:00 AM
Hi,

1.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

2. You could still use BCP in sql express to load the txt files

Thanks
Hari
SQL Server MVP


[quoted text, click to view]

MAF
6/22/2005 9:40:28 AM
Thanks very much for your help.
It was very useful !
--
MAF <maf NO albert SPAM com>
1024D/4B5B304C : 316E BAA2 DF76 8948 ECE8 F679 B1B5 A78A 4B5B 304C

Hari Prasad a écrit :
[quoted text, click to view]
AddThis Social Bookmark Button