March 19, 2010 at 3:48 am
Hello,
First of all: I'm no DBA and unfortunately we've no DBA in the company.
I would like to ask you how I can copy a few databases from one server to another. Currently we're doing this by exporting the db and importing it in another one. All of this is automated, but currently we have some problems.
Therefore I would like to do this via Integration Services, but I've no idea how to start.
Can you help me? I tried to find a basic basic basic to-do list on the internet, but couldn't find it, if you have a good link it would be much appreciated!
Thanks in advance
Koen
PS both servers are running SQL Server 2008 and are connected on the same LAN.
March 19, 2010 at 5:13 am
The 'easiest' way to copy databases from one server to another is to do a backup and restore.
You could do this via a SSIS package or instead use the SSMS GUI or T-SQL.
You could also copy the data via an SSIS package but this would take a bit more work, the best place to start for this approach would be the import/export wizard.
But unless you have a reason for not doing the backup/restore approach i would use backup/restore
March 19, 2010 at 5:20 am
steveb. (3/19/2010)
...But unless you have a reason for not doing the backup/restore approach i would use backup/restore
me too!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply