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


 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 bcp the tool here?


Avatar of 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


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

Link to home
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! ;)

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