| Author |
 Topic  |
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
 Posted - 05 June 2006 : 18:43:40
|
That's the advice my host is giving me.
Currently the Access Database is 90+MBs and
with a heavily visited forum and the blog app
I built my host is not really happy with me.
I know host discussions are not allowed, but I
do feel I should name the host, simply since
Godaddy has some limitations when it comes to
MS SQL.
So, anybody has any experience with converting
Access to MS SQL through CSV?
Also, are there any things I need to keep in the
back of my mind about this?
Greets & thanks,
Dominic
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 05 June 2006 : 22:57:00
|
| I'm not sure what it is you're trying to do. You do not need to export an MS Access database to CSV to import it to MS SQL. |
 |
 |
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
Posted - 06 June 2006 : 08:19:51
|
Yeah, I read something about remotely converting the current access database, but
my host doesn't support that, so this is the supported method they adviced me.
Greets & thanks,
Dominic |
CLPPR.com - All The News Only Seconds Away |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 June 2006 : 17:18:32
|
Get yourself a local sql server of the same version as your host. Stop your forum. Download the Access mdb. Convert it to sql server locally. When you're satisfied with the conversion, use DTS to transfer the mssql database to the host mssql server. Edit your forum config.asp to point to the mssql db. Restart your forum.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 09 June 2006 : 17:05:58
|
I guess I just couldn't imagine using a host that didn't allow me access to my database :)
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
Posted - 14 June 2006 : 16:59:40
|
Not really an option, cause aside for this thing I am satisfied with what their offering me
and with the traffic illhill gets I need the gbs they give me as far as traffic and storing and
switching can mean a site being down for a week or so, so not looking forward to that.
(But that would become a host discussion, so I end it at that).
Anybody has any experience with it and with the different tables the snitz db uses is there a
way to do it through CSV?
Greets & thanks,
D
|
CLPPR.com - All The News Only Seconds Away |
|
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
Posted - 04 September 2006 : 14:29:56
|
Anybody did anything through CSV yet?
Or found a solution that doesn't involve external access to the DB?
(this is still bugging me like crazy and due to a lack of any experience
with MSSQL I have a hard time visualizing any suggestions made).
Greets & Thanks,
D
|
CLPPR.com - All The News Only Seconds Away |
|
|
|
ILLHILL
Junior Member
Netherlands
341 Posts |
|
| |
Topic |
|
Topic Locked
?