| Author |
 Topic  |
|
Zuel
Average Member
USA
540 Posts |
 Posted - 08 October 2006 : 11:48:30
|
Is this possible?
Majority of the Searches just point to using DTS.
I do not see that option on my host. I haven't asked yet either.
I have a Plesk Control Panel with an online version of Enterprise Manager. Doesn't have full features as I would have liked, but it does work. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 08 October 2006 : 11:56:11
|
| DTS is the easy way, but there's nothing to stop you creating another set of 'linked' tables from sql server and copying the data over (slowly) via the client PC. |
 |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 08 October 2006 : 12:40:00
|
quote:
Originally posted by pdrg
DTS is the easy way, but there's nothing to stop you creating another set of 'linked' tables from sql server and copying the data over (slowly) via the client PC.
Is there any posts that describes on how to do that? |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 October 2006 : 13:15:18
|
Zuel,
The first thing you should do is create the forum tables in SQL using the forums setup.asp once you have done that, you can then transfer the data across either using linked tables in access or via DTS, if you feel confident and trusting enough, you can email me your logon information for Plesk togather with a copy of your access db (if it's not too large) and I can do the transfer for you. If access db is large you could maybe provide ftp access to it so I can download it and do the transfer.
You can email me via the forums with login info and I will email you back so you can send me the db |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 08 October 2006 : 15:30:41
|
| Zuel, now there's an offer you can't turn down! |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 08 October 2006 : 21:49:20
|
quote:
Originally posted by HuwR
Zuel,
The first thing you should do is create the forum tables in SQL using the forums setup.asp once you have done that, you can then transfer the data across either using linked tables in access or via DTS, if you feel confident and trusting enough, you can email me your logon information for Plesk togather with a copy of your access db (if it's not too large) and I can do the transfer for you. If access db is large you could maybe provide ftp access to it so I can download it and do the transfer.
You can email me via the forums with login info and I will email you back so you can send me the db
Ah thanks HuwR.
I'll send you the information in a minute via email. The email should provide everything you need. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Zuel
Average Member
USA
540 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 09 October 2006 : 04:15:48
|
| I haven't recieved an email from you Zuel |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 09 October 2006 : 10:09:31
|
Check your junk mail?
I sent it via snitz.
You can email me at ucyimDa_Ruler@hotmail.com then I can reply back if you don't want your email public. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
Edited by - Zuel on 09 October 2006 10:17:39 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 09 October 2006 : 11:22:10
|
my snitz address does not get Junked  I run my own mail server so no exactly where all my mail goes |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 09 October 2006 : 13:14:53
|
| Plesk is down again, they just had a hard drive failure on one of their servers and working to get it up. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Panhandler
Average Member
USA
783 Posts |
Posted - 09 October 2006 : 22:42:17
|
Zuel,
You might want to take a look at this product:
http://www.sqlmaestro.com/products/mssql/maestro
It has a free download and trial period.
Its very easy to use and I think that I read that it could do Access to MS SQL conversions.
Myself, as a novice, I was able to load and run MSSQL queries within about ten minutes after downloading it. (I don't even know what a query is, but it worked!)
Pan
|
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 09 October 2006 : 23:38:06
|
HuwR actually got this done for me.
And while he was doing that, a DBA at the City showed me how to do it if I were to connect to the DB via Enterprise Manager. I can do that myself now but thanks to HuwR it was done right the first time. He also got the SQL Server IP so I can just plug that in and go.
I've used Enterprise Manager daily so the features aren't too alien but thanks for the link. I shall pass it to the clients I have that don't have the enterprise manager utility. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
bud_dadude
Starting Member
Australia
21 Posts |
Posted - 12 November 2006 : 18:59:24
|
| You can upgrade Access to SQL by using the Upsizing Wizard that comes with MS Access. Very easy |
|
|
|
bud_dadude
Starting Member
Australia
21 Posts |
Posted - 12 November 2006 : 20:09:30
|
| I did it with Microsoft SQL Server 2005 Express (which is free by the way) and it all works very well. The upgrade from Access too around 10 minutes. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 13 November 2006 : 01:24:42
|
quote:
Originally posted by bud_dadude
You can upgrade Access to SQL by using the Upsizing Wizard that comes with MS Access. Very easy
Actually, that's not such a good idea. If I remember right, it won't carry over your indexes and some other items... you are infinitely better off using the directions rui posted around here somewhere. |
|
|
|
Topic |
|
Topic Locked
