Category Archives: Database

Configuring the MyEclipse DB Browser to View the Liferay Portal Database

Assumption: Liferay 5.1.2 on tomcat using default HSQLDB, which comes pre-configured with the download Steps: Switch to the MyEclipse Database Explorer perspective In the DB Browser window, right click, and choose New… Fill in the fields with the values shown … Continue reading

Posted in Database, Eclipse, Java Development | Leave a comment

Taking a SQL Server Database offline

I’ve had to take a SQL Server database offline several times lately, and I keep forgetting the names of the commands I need to use, so I’m saving them here for future use. To take the database offline: ALTER DATABASE … Continue reading

Posted in Database, Miscellaneous | Leave a comment