| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 3 of 3
-
May 10, 2009, 00:35 #1SitePoint Evangelist
- Join Date
- May 2006
- Posts
- 457
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
MSSQL: update tables from .sql file
Hello all,
I have just upgraded from MSSQL Express to MSSQL Workgroup.
Just wondering what the best way would be to actually update certain tables in a database from a .sql file?
-
May 10, 2009, 01:27 #2SQL Consultant
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 38,947
- Mentioned
- 52 Post(s)
- Tagged
- 2 Thread(s)
from a .sql file? just execute it
-
May 10, 2009, 06:48 #3SitePoint Evangelist
- Join Date
- May 2006
- Posts
- 457
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I have tried just executing.
Open SQL Server -> New Query -> open .sql file -> Execute
However I receive a System.OutOfMemoryException error.
Bookmarks