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

[Pho3nix]

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