Copy table data without linked servers
We have a SQL Server 2008 database and I need to copy data from several
tables to a SQL Server 2005 database after truncating the tables in 2005.
I've used the import/export wizard and that works. However, I don't have
permissions to save the package.
These are also not linked servers (and can't be made to be).
My question is, is there someway to add this to my truncate table script
and exceute it in mgmt studio? It is a pain having to go through that
wizard every week.
This is a corporate environment so getting additional permissions, setup
is not really viable.
No comments:
Post a Comment