Migrating data between SQL Server 2005 installations

Hello,

We have two SQL server installations on different machines. In ole' Enterprise Manager, it was easy to use their Data Transformation tools (Import/Export) to move data and schema back and forth.

What is available for SQL Server 2005? Anything in Visual Studio 2005? Or SQL Server Studio Management Express?

Thanks,

Steve
skbohlerAsked:
Who is Participating?
 
Daniel WilsonCommented:
The replacement for DTS is SQL Server Integration Services (SSIS).  For basic import / export stuff it works pretty much the same way as DTS.

You do need to install Integration Services on your client machine to successfully complete the wizard.  but in Management Studio, right-click the DB and choose Tasks ... Import Data... (or export data) and complete the wizard.
0
 
skbohlerAuthor Commented:
Thanks.
0
 
skbohlerAuthor Commented:
One more thing.

Will the Integration Services also migrate to an SQL Server 2005 Express edition database?

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.