you can't directly move the contents as using the MSSQL Enterprise Manager DTS..
but you can export the table creation structure & the data and then import it.
look on top there is a tab "EXport" select table structure if you want to createtables as well. or just the data if you want to import the data only.
