Ed.Edwards (9/22/2010)
I don't understand why there are no export/import utilities in SQL Server. Oracle, DB2 (LUW), and MySQL have export and import utilities. SQL Server 6.5 had export/import utilities.
You mean like bcp, BULK INSERT and SSIS?
You can set up an export package via the import/export wizard (right click a database, tasks-> export data), save the package and then set it up as a SQL Agent job. Same with an import wizard package
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability