Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : Access to MS SQL from Shared to VPS please help

[charto911]

I just upgraded to a VPS from a shared host on 1and1.com and with the new setup I need it to port over access and convert it to ms sql as the database doesnt work in a linux server with out being tweaked as dates and # symbols change things up.

Any who who can please help me I am desperate and this is killing me

[DeltaAnime]

You'll need to install the MSSQL plugin for PHP.

You also need to update your connect lines to include the port

Francisco

[kpmedia]

Converting databases is NOT as easy as it sounds.

[charto911]

Tell me about it KP. So here is what I have done and am going to be doing: forwarding via 301 redirect to a site that has a similar domain name that I put on the shared server that works with the original site be4 the move. I will port over the vps site back to the shared (with the correct url) tonight or tomorrow and than will get somebody who actually knows how to configure the site for the VPS to set it up properly and than redirect it back to the new server.

Question is will this 301 affect my SEO since I am on a different url now?

[Douglas]

This should help you a bit.

http://support.microsoft.com/kb/237980

[kpmedia]

For temp redirect, use 302, not 301.

[charto911]

KP are you sure this wont screw up my rankings? As 301 has and I am switching now once the crawlers see this will they re-rank me?