Link to home
Start Free TrialLog in
Avatar of sebadlington
sebadlingtonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Transferring 10gb + databases to another database on the same server, whats the best way

Hi,

 I need to transfer some exisiting databases to a new database on the same server. The databases are going to be typically 10gb and over and mainly contain BLOB file images. I can do a straight copy but it has a severe impact on the server, I realise there is no quick way to do this but am looking  for the most minimal impact on the server....is bcp the tool here?

Thanks

Seb
Avatar of skullnobrains
skullnobrains

transfer a database to a database has little meaning
are you trying to transfer a table from one database to another ?

if so, i'm not sure you can do much better than
select * from source into db.dest
Avatar of sebadlington

ASKER

Yes sorry - transferring one table into another table in a different database
ASKER CERTIFIED SOLUTION
Avatar of skullnobrains
skullnobrains

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yeah thanks mate - was just hoping there was some super fast utility floating around out there! ;)

Cheers
there may be but if there is, i'm not aware of it, sorry

the speed transfer should be relatively constant or a large scale (several Go), so you can schedule it easily and possibly copy in chunks during non-busy hours
Chunks was the plan I think - did a small test and it looks like it was going to take about 3 days constant!
ok, i guess you know what you are doing.
feel free to post if you need help somewhere in the process