Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Migrating data between SQL Server 2005 installations

Posted on 2008-10-14
3
Medium Priority
?
226 Views
Last Modified: 2012-05-05
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
Comment
Question by:skbohler
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 22714848
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
 

Author Comment

by:skbohler
ID: 22714892
Thanks.
0
 

Author Comment

by:skbohler
ID: 22717160
One more thing.

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

Steve
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question