crcsupport
asked on
Copying one table from sql 2005 to sql 2008
I have a table generated daily on sql 2005 and I have to copy the table to sql 2008 on a different machine. I manually did this by generating scripts with data on sql 2005 and run the script on sql 2008, it worked, but running the generated script takes too long. The script file is about 150MB.
What option do I have besides generating scripts to copy a table between SQL 2005 and 2008 on two different machines?
What option do I have besides generating scripts to copy a table between SQL 2005 and 2008 on two different machines?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the option.
Is there any option that I can automate the import/export like task scheduling? Maybe if I can get the script of the task, I can schedule it, but where do I find the script?