MS Sql Server Local DB

-

Web.Config file:
<add connectionstring="Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=[database-name]; Integrated Security=True" name="ConnectionString" providername="System.Data.SqlClient" />

Connect to Local DB:
Open Visual Studio: Menu: Tools > Connect to Server >
Left navigation bar > New Data Connection: Server Name: (LocalDb)\MSSqlLocalDB

drop database "myDB"; 
create database "myDB";

-- Check the logical file name (1st column) after running this query
RESTORE FILELISTONLY FROM DISK = 'E:\Ismail\Projects\VPT_TVL\vpt\database\VPT.bak';

-- Place the Logical file name after MOVE statement, and a path where database files will be created
RESTORE DATABASE "myDB"
FROM DISK = 'D:\database\myDB.bak'
WITH MOVE 'myDB_Data' TO 'E:\database\TVL_PT_Data.mdf',
     MOVE 'myDB_Log' TO 'E:\database\TVL_PT_Log.ldf',
REPLACE;

Comments

Post a Comment

Popular posts from this blog

Crystal Report FAQ Error and Fixes

-
CrystalReports Crystal Report Versions: CrystalReports.com CrystalReports.com/download/ Crystal Reports, Developer for Visual Studio Downloads Common Errors for runtime version: 13.0.22.2668 Error: Failed to load database information. Details: Error in File rpt*** 17596_15752_{FC2EA1BF-082D-4345-947E-BE235A441BFD}.rpt: Failed to load database information. Details: System . Web . HttpExceptionThe file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . System . Web . HttpException ( 0x80004005 ) : The file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . at System . Web . UI . Util . CheckVirtualFileExists ( VirtualPath virtualPath ) at System . Web . Compilation . BuildManager . GetVPathBuildResultInternal ( VirtualPath virtualPath , Boolean noBuild , Boolean allowCrossApp , Boolean allowBuildInPrecompile , Boolean throwIfNotFound , Boolean ensureIsUpToDate ) at System . Web . Com...
Read more

Export DataTable or DataSet to CSV or XML

-
using System ; using System.Collections.Generic ; using System.Configuration ; using System.Data ; using System.Data.SqlClient ; using System.IO ; using System.Linq ; using System.Text ; using System.Web ; using System.Web.UI ; using System.Web.UI.WebControls ; using System.Xml.Serialization ; public partial class ExportReservationInfo : System . Web . UI . Page { #region Events protected void Page_Load ( object sender , EventArgs e ) { lblMsg . Text = "" ; if ( Page . IsPostBack ) { } } protected void btnExportToCSV_Click ( object sender , EventArgs e ) { string strReservationId = txtReservationId . Text . Trim (); DataSet ds ; try { int ReservationId = Convert . ToInt32 ( strReservationId ); ds = ExecuteQuery ( ReservationId ); //Export to CSV ExportToSpr...
Read more

Linux Command ref

-
Basic Operational Commands: Show users logged in: $who $who am i To list the files/Directories: $ls $ls -l Navigate to a location GoTo root directory: $cd / GoTo /home/oracle directory $cd /home/oracle GoTo 1 level up $cd .. To Concatenate files and print on the standard output $cat System Admin Commands : Show System info: $uname $uname -r Show kernel info $cat /etc/issue To determine available RAM and Swap space: $free To determine the Physical RAM size: $grep MemTotal /proc/meminfo To determine the size of configured Swap space: $grep SwapTotal /proc/meminfo To determine available disk space: $df -k $df -k /tmp $df -k /u01 To mount a PenDrive Insert pen drive into USB device, To mount pen drive use mout command. Find out device name using $fdisk –l You may see /dev/sda as pen drive and /dev/sda1 as partition. Now create directory in /mnt $mkdir -p /mnt/usbpen Mount pen $mount /dev/sda1 /mnt/usbpen
Read more