What is best way to run script against MS-SQL?

The problem is a script to include data. If your db is anything over a gig it becomes incredibly difficult to work with as I found I start running out of memory when trying to run it.

Backup data separately.
Run changes.
Apply data.

Or

SSIS
 
Top
Sign up to the MyBroadband newsletter
X