Page 1 of 1
what are our the possible ways to migrate database!URGENT!
Posted: Wed Apr 14, 2004 8:21 pm
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?
Posted: Wed Apr 14, 2004 8:42 pm
by litebearer
Posted: Wed Apr 14, 2004 9:05 pm
by Drayton
bro thanks for the help, but i rily newbie on handlig such database, is there easy way to do migration?
Posted: Thu Apr 15, 2004 1:38 am
by litebearer
do you have Access and Mysql on the same server?
Posted: Thu Apr 15, 2004 1:57 am
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!
Posted: Thu Apr 15, 2004 2:16 am
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.
Posted: Thu Apr 15, 2004 2:51 am
by Drayton
Ei bro thanks a lot it enlightens me a lot more about SQL servers. thanks!