Restore/attach database in MS SQL Espress 2005

r.federiconi · Post by **r.federiconi** » Wed Sep 16, 2009 12:04 pm

HI,
we bought InstallAware studio 9, how can I restore/attach database in MS SQL Espress 2005?

neillans · Post by **neillans** » Thu Sep 17, 2009 3:34 pm

You can do this using a T-SQL command through any of the MS SQL plugins available (either ours or third party).

DevilSun · Post by **DevilSun** » Fri Sep 18, 2009 11:46 am

Very true, it's up to the T-SQL you write. Just remember, you can issue T-SQL commands to remote SQL servers, but that machine may not have the database to restore/attach physically available (i.e. running install from current machine point to remote SQL server)...so for this reason, we create the database entirely through a script.