Gezza Golden Oldie Golden Oldie Sep 23, 2008 2,202 65 135 uk Jul 12, 2009 #1 Is it possable in any way to transfere a sql 05 database to sql 2000? Last edited: Jul 12, 2009
boothy LOMCN Veteran Veteran Mar 23, 2007 458 12 45 Jul 12, 2009 #2 never used sql 2005 but i suppose you could just export all the tables out into a microsoft access file then import it back into sql 2000? Upvote 0
never used sql 2005 but i suppose you could just export all the tables out into a microsoft access file then import it back into sql 2000?
Gezza Golden Oldie Golden Oldie Sep 23, 2008 2,202 65 135 uk Jul 12, 2009 #3 Yeh dunno how to do that on 05, i know how to do it with 2000. Upvote 0
Kaori LOMCN MiR3 Queen! VIP Jun 3, 2004 3,584 38 265 Canada Jul 12, 2009 #4 With both server ON, you can do a server to server import/export. Upvote 0
Gezza Golden Oldie Golden Oldie Sep 23, 2008 2,202 65 135 uk Jul 12, 2009 #5 What it is i got sql 05 on my comp and on the dedi it has 2000, can i still import that way? if so can u give me a quick short guide thx. Upvote 0
What it is i got sql 05 on my comp and on the dedi it has 2000, can i still import that way? if so can u give me a quick short guide thx.
Kaori LOMCN MiR3 Queen! VIP Jun 3, 2004 3,584 38 265 Canada Jul 12, 2009 #6 yes you can still do that as long as the port is accessible. do your export from 2005... instead of ms access as "Destination", use sql server. and point that to your dedi. port 1433 is the default port for sql 2000 Upvote 0
yes you can still do that as long as the port is accessible. do your export from 2005... instead of ms access as "Destination", use sql server. and point that to your dedi. port 1433 is the default port for sql 2000
