Groups | Blog | Home
all groups > sql server msde > march 2006 >

sql server msde : SQL Server 2005 Express Import/Export


Randy
3/21/2006 2:19:26 PM
Is there an Import/Export wizard like SQL Server 2000?

I am thinking of developing databases in SQL Server 2005 Express.
When done I will need to transfer the tables/data to a SQL Server 2000
database.
I normally use the "Import and Export Data" tool to transfer items.
Is there a matching tool in SQL Server 2005 Express?
Would this tool handle going from SQL Server 2005 to SQL Server 2000?
Thanks in advance,
Andrea Montanari
3/22/2006 12:00:00 AM
hi Randy,
[quoted text, click to view]
SQLExpress does not provide BI tools (DTS Wizard in SQL Server 2000) to
perform this kind of oerations... you have to manually perform data-pumping
the way you like.. BCP, BULK INSERT, INSERT INTO, ADO.Net/ADO or the like..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button