backupsql serversql-server-2008-r2
I have a SQL Server script file which ranges size of 3gb and I am in need to upload the script file to an external server.
i generated script for my 6gb database by following these steps
right-clicked the database–>tasks—>genrate scripts–>script entire database and objects and at scripting options i clicked advance –>type of data to script–>set it as schema and data and finished the data..
What are the shortest methods to upload faster into the server?
I would not remove the GO statements that break up large batches. There are various reasons for breaking large inserts
As for removing the status updates, that can be done easily. Press Ctrl-H or from the menu, Edit -> Find and Replace -> Quick Replace, fill it in as shown in the image below making sure to tick "Use" Regular Expressions, then click on "Replace All" to zap them all.
For SSDT, when you choose Publish to generate a script the advanced options include "Always re-create database". Untick that and you're good to go.
Same option applies if you do a local debug build.
Similar options buried in the old VS2010 Database Project options somewhere.
To be honest, from the description of what you're doing SSDT and/or VS2010 database projects are overkill. Scribble a script in SSMS and be done with it.
Best Answer
If by "SQL Server script file" you mean a generated file with lots (and lots) of inserts to recreate your data then I would recommend a different approach.
I'd personally go with a database backup (why aren't you using that), but failing that I'd probably use a BCP extract. As a BCP exports the data in the format its stored you should get a smaller file. You can then compress this too with your choice of compression tool (e.g. zip).
Couple of notes on BCP: