sql - How can I generate script of database by using backup file (.bak) -


i want generate portable script file of sql server database using backup (.bak) able create database (with objects , data) without backup file.

i don't want restore backup file sql server management studio achieve it.

is possible?

how can achieve it?

follow normal procedure restore db on last screen generate script rather clicking ok:

restore

then can use same script or modify after.


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

c++ - Problems with pointers char **words; -

so i'm deleting pointers in functionr resetline(), , assigning them in function breakline(). i'm getting core dump, think i'm either deleting pointers wrong, or trying use null pointer somewhere in program. although can't see problem myself. appreciated! #include"online.h" //public funcions----------------------------------------------------- //creator function oneline::oneline() { oneline = ""; wordcount = 0; } //destructor oneline::~oneline() { //if allocation has occurred free words if(wordcount > 0) { delete [] words; } } istream& oneline::readline (istream& is) { //call resetline free memory , reset oneline , wordcount empty string , 0 respectively char test[12] = "heythere"; resetline(); //read 1 line (in case, file stream) , store in oneline { if(!getline(is, oneline)) // if eof reached return is; }while(oneline.empty()); //check empty lines //return return is...
Read more