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?
what are our the possible ways to migrate database!URGENT!
Moderator: General Moderators
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
Might look here
http://www.kitebird.com/articles/access-migrate.html
and/or here
http://www.intranet2internet.com/public ... TAILS=DUMP
http://www.kitebird.com/articles/access-migrate.html
and/or here
http://www.intranet2internet.com/public ... TAILS=DUMP
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
hmmmm...
source: http://www.winnetmag.com/SQLServer/Arti ... 23914.html
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.