Ms Sql Server Express Portable • Quick

CREATE DATABASE MyDatabase ON (NAME = MyDatabase_dat, FILENAME = 'E:\PortableSQL\Data\MyDatabase.mdf') LOG ON (NAME = MyDatabase_log, FILENAME = 'E:\PortableSQL\Data\MyDatabase_log.ldf'); GO attach.sql

Verify installation by opening Command Prompt and typing: ms sql server express portable

@echo off echo Starting LocalDB... SqlLocalDB start MSSQLLocalDB echo Attaching database from USB drive... SqlCmd -S (localdb)\MSSQLLocalDB -i "%~dp0attach.sql" echo Ready. Connect using (localdb)\MSSQLLocalDB pause FILENAME = 'E:\PortableSQL\Data\MyDatabase_log.ldf')