Re: Transferring partail DB from old SQL to new SQL Box!

Laslo Orto ( )
Wed, 03 Dec 1997 12:05:55 -0500

I think that the easiest solution for you is to manualy re-enter them.
Transfering them could be very long and painfull.
Just think of all the duplicate identities in all the different tables

Next time make sure you drop all the permissions on the old database after
moving the server, this way they simply wont be able to enter anybody new
and you'll know about it immidiately. It happened to me too, but i caught
it after less then 10 accounts :)

At 09:11 PM 12/2/97 -0600, you wrote:
>I need some help... We are in the process of switching to a new SQL server
>machine and
>like an idiot, I forgot to tell one of our locations to stop entering
>people into the old system..
> I have 200 records sitting in the old server that I would like tranfer
>over to the new one.
>Question is: How can I re-transfer the old DB to the new DB without
>"hurting" the new
>data that has been entered? I am SQL clueless so detailed instructions
>would be nice.
>Take care,
>Barry Kiesz (
>Internet System Administrator
>Hard Drive Central - LOCAL ACCESS IN:
>423 Moccasin Drive Voice 605.229.1562 - Aberdeen,Yankton,
>Aberdeen,SD 57401 Fax 605.229.1563 - Mitchell,Watertown,
> - and Sioux Falls! Flat-rate unlimited Local dialup for only
>Commercial Web Hosting starting at only $10.00/month
> ----------------------------------------------------------
> Emerald Mailing List
Laslo Orto Computer Pages / Better.Net
Systems Administrator 253 Sheppard Ave. West / Toronto, Canada M2N 1N2 / Ph: +1 416 225 3030
Fax: +1 416 225 6737