what are our the possible ways to migrate database!URGENT!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Drayton
Forum Newbie
Posts: 24
Joined: Thu Apr 01, 2004 2:14 am

what are our the possible ways to migrate database!URGENT!

Post by Drayton »

HI To all concerned programmers,

I'm a newbie on php, but i've created some applications using php, my problem is that a new server is set up on our clients in our company, since both our chief technical engineers are out of town i was asked to "VB migration from Access to MS SQL. Can Someone help me?
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

User avatar
Drayton
Forum Newbie
Posts: 24
Joined: Thu Apr 01, 2004 2:14 am

Post by Drayton »

bro thanks for the help, but i rily newbie on handlig such database, is there easy way to do migration?
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

do you have Access and Mysql on the same server?
User avatar
Drayton
Forum Newbie
Posts: 24
Joined: Thu Apr 01, 2004 2:14 am

Post by Drayton »

bro tanx eniweys. i just got informed that i got the wrong info from the clients, they are using SQL Server 6.5 and i have to migrate the whole database to anther server which runs on SQL Server 7.0 can u help me with that? thanx!
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

hmmmm...

source: http://www.winnetmag.com/SQLServer/Arti ... 23914.html
Creating SQL Server 7.0 versions of your SQL Server 6.5 database is possible, but doing it the easy way requires downtime at both the target and source databases. (Don't attempt this project in prime time!) The SQL Server Upgrade Wizard will create these databases for you. The wizard contains a specialized OLE DB driver that can read SQL Server 6.5 files, convert the 6.5 database structure into a SQL Server 7.0 equivalent, then create the scripts required to copy over the objects (and data). This process requires full access to the SQL Server 6.5 files and hence downtime. In addition, to load the SQL Server 6.5 files into SQL Server 7.0, the wizard has to start the loading process with a specific trace flag, which requires stopping and starting the SQL Server 7.0 instance. Here are the steps you need to take to convert the databases.
User avatar
Drayton
Forum Newbie
Posts: 24
Joined: Thu Apr 01, 2004 2:14 am

Post by Drayton »

Ei bro thanks a lot it enlightens me a lot more about SQL servers. thanks!
Post Reply