Forum data transfer – SQL

20 pts.
Tags:
SQL Database
SQL Database Transfer
Hi, my question is: we're developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give the steps to do it.

Thank you very much!



Software/Hardware used:
Microsoft SQL Server, ASP.NET
ASKED: March 4, 2010  7:40 AM
UPDATED: March 5, 2010  1:16 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Assuming that you have access to the SQL Server database you can use DTS or SSIS to transfer the data between the two databases.

Thank you Sir! We’ll do it accordingly in one or two months and let you know.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following