| Author |
 Topic  |
|
JohnC
Junior Member
215 Posts |
 Posted - 06 February 2007 : 11:57:03
|
| daveo, if you want to convert it for me I wouldn't mind paying you for your time. I have a PayPal account. What formats can you do: MySQL, MS SQL 2005?< |
Edited by - JohnC on 06 February 2007 11:57:30 |
 |
|
|
daveo
New Member
97 Posts |
Posted - 08 February 2007 : 00:06:04
|
| I can do SQL 2000 and 2005. I can read access including 2007. Also Excel. I just got back from a trip north in this cold and am thawing out. How big is the database?< |
http://copdforum.portalone.us/ |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 08 February 2007 : 09:42:19
|
The Access database is 54MB in size. I guess I would want it migrated to 2005, assuming it will work attached to a server that calls for 2005 Express. I have 2005 Express server resource available to me with my host but I was leaning toward MySQL because I have more tools and more resources available. Then again, 2000 might be easier to migrate to MySQL if I can’t get the 2005 database to work on my hosts’ Express server. Do you have an idea on what you will want to charge? You can also contact me via email if you want. I appreciate your consideration!  < |
|
|
|
daveo
New Member
97 Posts |
Posted - 08 February 2007 : 18:06:12
|
If you can do some mods for me, I will exchange services. I want to add some more mods to my forums and my programming is a little rusty.
If you want me to try it, I will give you FTP info and you can upload it. I will tell you if it is more than incidental time.< |
http://copdforum.portalone.us/ |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 14 February 2007 : 21:56:09
|
I really need my database migrated to somoething and I'm willing to pay someone to do it. I have PayPal. Anyone have a fullproof method? No longer needed.< |
Edited by - JohnC on 17 February 2007 10:28:16 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 15 February 2007 : 05:47:13
|
JohnC - didn't daveo just offer to do it for you? He even offered to do it for a skills swap, but I'm sure he'd also be happy to take your money!
If not, I'll take your money for it, but I don't know if you can afford me...< |
|
|
|
daveo
New Member
97 Posts |
Posted - 17 February 2007 : 11:59:35
|
| It turned out he had MySQL, not access. I have migrated access to MS Sql, but have minimal experience with MySQL.< |
http://copdforum.portalone.us/ |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 18 February 2007 : 10:24:49
|
| Ahhh well, maybe someone will take you up on your offer sometime ;-) Looks like JohnC is sorted too, anyway.< |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 24 February 2007 : 17:37:47
|
Ours was actually MS Access to MS SQL 2005 Express, which is now done. Big thanks to Rui!
Outside of some glitches with our hosting company, our forums are running flawlessly and very fast with MS SQL 2005 Express.
We did have to do one minor change though, and that was to use Rui's version of search.asp because searches were timing out.< |
Edited by - JohnC on 25 February 2007 09:58:42 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 24 February 2007 : 19:18:05
|
Good to know, thanks for the update posts too (this and the other thread)  < |
|
|
|
Steve B
Starting Member
11 Posts |
Posted - 02 March 2007 : 15:17:04
|
I recently discovered that I need to upgrade my Access database to SQL Server. I'm not a DBA, but your instructions here seem to be detailed enough that even I can probably handle it. Once I've created the database in my hosting company's Site Control Panel page, their instructions consist pretty much of "1. Start - Programs - Microsoft SQL Server 2. Launch Enterprise Manager"
I do not have access to Enterprise Manager. Do I have any other options? Are there readily available (i.e. free and downloadable) tools I can use?
Thanks,
Steve< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 02 March 2007 : 15:24:37
|
| While I can't say with absolute certainty, odds are good if they won't let you use EM they probably won't let you use any other tools of equal calibre... what those would be, I couldn't say.< |
|
|
|
Steve B
Starting Member
11 Posts |
Posted - 02 March 2007 : 15:40:27
|
| I'm not sure I understand - probably because as I said, I'm not familiar with EM and don't know exactly how it works. But from what I'm reading here, it sounds like I can run it locally and point it to the IP address of my database, and that agrees with what their Site Control Panel page says. The problem is not that they won't let me use EM, but that I don't have it. Are there other tools that would allow me to manage the database similar to EM? Or am I out of luck?< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 02 March 2007 : 15:59:03
|
Ah, I misunderstood. When you said "I do not have access to Enterprise Manager" I thought you weren't allowed access, not that you just didn't have it...
There is a new SQL Server management tool that Microsoft has out, I just don't remember what its called. You may or may not be able to use it - http://www.microsoft.com/sql/default.mspx might be a good place to start looking. Also, http://www.sqlmanager.net/ used to have an EM-like SQL Server manager that was free (and the really killer version cost some $$$)... couldn't seem to find it though.
I should probably add that I don't know how well either program will work as a substitute... make backups.  < |
Edited by - AnonJr on 02 March 2007 15:59:55 |
|
|
|
Steve B
Starting Member
11 Posts |
Posted - 03 March 2007 : 21:35:11
|
I've downloaded and installed the evaluation version of SQL Server 2005. It's good for six months, which ought to get me past this upgrade thing!  BTW, I don't see Enterprise Manager, but there is a "MS SQL Server Management Studio." It doesn't seem to map well to the descriptions given here, but I'm hoping I can make it work. Or am I missing something really big here?
I've managed to connect to the MS SQL database I created the other day, so that's good. I haven't run setup.asp yet because I need to close the forum and backup the Access database before I make any changes, and I want to make sure I have everything else ready to go first. So I'm looking at the next step, which is to import the data from the old database.
I hate to admit it, but I'm stumped. I do not have login access to these servers, only http, ftp, and whatever SQL EM (or SMS) uses. The Access and SQL databases are on different servers. The current connect string for the Access database is obviously not usable, since it's based on the local disk layout - e:\something\or\other\whatever.mdb. Can I specify the IP address and get to it somehow? (Oddly, when I try to browse to the database or the whereami.asp file in the same directory, I get a "The requested resource could not be found" error.) Anyway, I'm not sure how to connect.
Any help would be greatly appreciated. I'm feeling like I'm in way over my head!
Thanks,
Steve< |
|
|
|
Topic |
|
Topic Locked
