Wednesday, October 21, 2009

Moving database file and renaming database file

exec sp_helpdb DatabaseName

datach:

exec sp_detach_db 'MyDatabase', 'true'

attach:

exec sp_attach_db 'MyDatabase',
'C:\Program Files\Microsoft SQL Server\MSSQL\data\MyDatabase_Data.MDF',
'C:\Program Files\Microsoft SQL Server\MSSQL\data_log\MyDatabase_Log.LDF'

Change logical file name:

alter database MyDatabase modify file (name='test', newname='MyDatabase')
alter database MyDatabase modify file (name='test_log', newname='MyDatabase_log')

source: Timothy Chen Allen

Tuesday, October 20, 2009

A quick tutorial on using hibernate for webapp

Directly from Netbeans KB:
http://www.netbeans.org/kb/docs/web/hibernate-webapp.html
However, don't expect to learn much from this over simplified tutorial.

Monday, October 19, 2009

Using Netbeans and Eclipse side by side with SVN

while I was doing the group assignment for comp9323, I thought about using netbeans and eclipse side by side. Initially I preferred Netbeans but after all I was using Eclipse for the project.
After playing around Subversion and Netbeans/Eclipse for a while, I actually realize that this can be setup in a way that netbeans and eclipse can be used side by side in same project. In my case, I created the source repository in SVN then synchronize it with Eclipse, later I use Netbeans to check out a copy then follow the instructions to create netbeans project, when it complaints about existing build folder, just remove the build folder then you can proceed.