<div>
hi<br />
<br />
<a href="http://www.mssqltips.com/tip.asp?tip=2064" rel="ugc">http://www.mssqltips.com/tip.asp?tip=2064</a><br />
<br />

</div>


<div>
in the run type:<br />
dtswizard<br />
and then import/export wizard will appear, set source as sql 2005, destination as sql 2008, and then select tables and do mappings.<br />
But if you want to move your current SQL 2005 database totally to new SQL 2008 database, I suggest to backup on 2005 and restore on 2008.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp; &nbsp; Please guide &nbsp;me on steps &nbsp;to do Import and export &nbsp; &nbsp;using GUI. &nbsp;
</div>
</div>


Hi,
      Please guide  me on steps  to do Import and export    using GUI.  

hi

http://www.mssqltips.com/tip.asp?tip=2064



in the run type:
dtswizard
and then import/export wizard will appear, set source as sql 2005, destination as sql 2008, and then select tables and do mappings.
But if you want to move your current SQL 2005 database totally to new SQL 2008 database, I suggest to backup on 2005 and restore on 2008.



Import &amp; export wizard  sql 2005 2 to sql 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Import &amp; export wizard sql 2005 2 to sql 2008

Import & export wizard sql 2005 2 to sql 2008