July 15, 2007 at 8:37 am
Could anyone help me on how to import or export data from one database to the other. I can not find imports and exports in sqlserver 2005 express as it is in sqlserver 2000. thanks
July 17, 2007 at 5:23 am
You have to use SSIS to import/export data in sql 2005. They are part of integration services.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 18, 2007 at 2:24 am
Kumar, what do u mean by 'SSIS'. I am now learning so if you could break it down a bit. Thanks
July 18, 2007 at 4:55 am
2005 Express does not include SSIS - see http://msdn2.microsoft.com/en-us/library/ms143755.aspx
It seems you need to use bcp - see http://asptutorials.net/SQL-Server/sseutil-and-database-replication/
Good luck
Graham
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply