• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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
0
skbohler
Asked:
skbohler
  • 2
1 Solution
 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now