| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-08-25 : 14:05:44
|
| I need to transfer a huge amount of data from one server to another server locates across the countries over a narrow bandwidth.95% of the space is occupied by a single table (85 GB).This table has a Pk.Also has a Image column.Any suggestions or articles will be greatly appreciated.Thank you.------------------------I think, therefore I am |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-25 : 16:15:34
|
| I think I would dump the database and compress it....And instead of across the network, wouldn't it be faster to overnight tapes?Not to mention hiccups in the line?Brett8-) |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-08-25 : 16:55:16
|
| Since my target server doesn't have a tape drive or dvd drive. I can not use that option...------------------------I think, therefore I am |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-25 : 17:17:08
|
| Backup the database using SQL Litespeed. You can use the trial version to try out this product. With this product, your backup file size will be significantly smaller. It'll still be a quite a few gigabytes, so you'll need to find a solution to move that size file. We've used a USB drive before for this type of situation. We had an employee travelling between the two sites, so he just delivered it for us. But you can always express ship it.BTW, that's one of many reasons why images shouldn't be stored in the database. It makes it harder to manage.Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-25 : 17:50:42
|
| put it on an external hard drive (USB 2.0 or firewire) and ship it to them.If they don't have USB 2.0 or Firewire, they can just buy a card with this capability for 20 bucks or so. The external drive will cost you $150.-ec |
|
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2004-09-08 : 03:42:07
|
| Ravi,Hi Nitin here!You can transfer the database using SNAPSHOT replication method.It is quite safe and fast.Do you have any connectivity among source and target servers? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 12:12:18
|
| Why would you want to use snapshot replication? That's overcomplicating this.Tara |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-08 : 12:25:58
|
| Tara ...i am with you. I don't think snapshot replication will solve the issue.------------------------I think, therefore I am |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-09-08 : 13:26:11
|
| SQL Litespeed + some sort of portable Hard drive is the solution here.A USB 2.0 / Firewire or some SCSI / Fibre channel drive that they can pop into an existing enclosure.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-09-08 : 16:51:43
|
| Image storage in a database has some advantages, but to get the benefits you must at least be able to design a physical model that is maintainable. SQL Server doesn't have the media management of Oracle or DB2, but does it does have filegroups and files! Go read the manual.DavidM"Always pre-heat the oven" |
|
|
|
|
Transferring huge amount of data