| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 3 of 3
-
May 10, 2009, 01: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, 02:27 #2SQL Consultant
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
from a .sql file? just execute it
-
May 10, 2009, 07: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