title: Export database from SQL Server 2008 R2 Instance to SQL Express 2008
body: <p>I ran into a issue about Import/Export on SQL Server.
  <br>
  I have a database on SQL Server 2008 R2 instance running on my laptop.</p>
  
  <p>I want to attach it on a SQL Server Express 2008 instance running on Windows 2003 server.
  <br>
  Due there is no management studio on my server Is it possible to export database from SQL Server 2008 R2 to SQL Express 2008 instance ?<br>
  Depend on <a href="https://dba.stackexchange.com/questions/5923/attach-sql-server-2008-r2-on-sql-server-express-2008/5947#5947">this</a> answer I think its possible.<br>
  But when I want to use Import Export tool on destination setting I should choose destination configuration.<br>
  How can I get around this?
  <br>
  I want to know Is it possible to move R2 schema data to SQL Server 2008 express using Import / Export tool ?
  If yes I think it generate script for us and I don't have management studio on server. Is it possible to execute generated script on a management studio running on my system and then move MDF file to server ?
  <br><br>
  P S : Should I ask this question on <a href="http://dba.stackexchange.com">DBA</a> ?</p>