Is there an command line option to auto accept a SSL certificate permanently using the SVN commandline in a way that avoids the prompt?
In Sql Server 2005, is there any way, using the official GUI or a third party tool, to select rows in a table and then generate a insert script for the selected rows?
I'm trying to move a database from our production server to our test server. I've used Microsoft's Database Publishing Wizard to create a script containing the schema and data for the production database.
However **I can't figure out how to load this script into our test database.**The resulting script is about 500mb, which isn't 'large' by database standards but large enough that I can't copy and paste it into the query analyzer. Alternatively, when I try and open the file directly with the SQL Server Management Studio it complains
The operation could not be completed. Not enough storage is available for this operation.
This error happens before I select a database, so I believe it is the Management Studio complaining about not having enough memory to load a 500mb file.
Any advice?