| Author |
 Topic  |
|
Andy Humm
Average Member
United Kingdom
908 Posts |
 Posted - 24 January 2006 : 18:16:20
|
| I have been using the snitz forum with an access db for over 4 years and have been advised by my server host that to improve the speed & usage I need to change the db over to sql. How do I convert over to SQL without losing at the data records and have the same operatability. Is there a simple solution. rgds andy |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 24 January 2006 : 18:29:02
|
what is the easiest to use?
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 January 2006 : 18:34:20
|
| No difference, just a matter of which is supported by your host. With the proper tools I find migration easier in the MS SQL Server case, but it can be done with MySQL too. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 24 January 2006 : 18:38:01
|
| My server will accommodate both. Is there any easy migration tool using MS SQL, as it is new territory for me.. thnx |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 January 2006 : 18:53:28
|
This is the Access to SQL Server migration strategy: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31144
Tools needed are described there too.
MySQL strategy is pretty similar, though I have found the part about transferring the data to be a bit more tricky. The strategy that has given me the least problems to transfer the data was an ODBC data source creation and then use the ODBC source to export the data directly from Access. However, for this to work you need to have access to the MySQL Server from outside your host network (something that is not always possible). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 24 January 2006 : 19:05:32
|
Looks fairly straight forward, a bit of brain surgery really, but I'll give it ago.
Q1 Will the data be transferred across?
Q2.I have options for MS SQL 2000 and MS SQL 2005, are they both supported?
thnx in advance |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 January 2006 : 04:57:16
|
On your instructions to migrate db item 4
4. Use DTS to transfer the data from your Access database to your SQL Server database. You should make sure that for each table the DTS transform column is configured so that any existing table data is deleted and enable identity insert is checked.
what is DTS please |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 January 2006 : 05:37:56
|
| D(ata) T(ransformation) S(ervices) is a tool that comes with SQL Server. Previously it could be found with the trial for SQL Server 2000. Now with SQL Server 2005 I'm not sure whether it has changed names, but it should be included with the Trial too. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 January 2006 : 06:03:11
|
Ooh does my server host have these tools normally..
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 January 2006 : 15:58:27
|
My server host has stated that they do not have DTS facilities nor can we run online programs on the server, help!!
I have set the forum up, with mods etc, all I need to do is get the data from my old access database. Any step by step instructions would be greatly appreciated..
andy |
Edited by - Andy Humm on 25 January 2006 16:00:43 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 26 January 2006 : 03:45:31
|
unfortunately no
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 January 2006 : 04:30:40
|
If there is no DTS, I don't see you will be able to transfer the data without issues. Does your host have any suggestions?
What if you use MySQL? Can connections be made from the outside? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
