| Author |
 Topic  |
|
|
Dave.
Senior Member
USA
1037 Posts |
 Posted - 05 December 2003 : 22:09:43
|
OK, I should first Create the DB, Run the Setup install the tables, run my DBS Files, then move everything over from DTS? Correct?
My problem is how do I make sure DTS doesn't overwrite my "good" structure with it's "bad" one?
TIA |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
chad
New Member
50 Posts |
Posted - 06 December 2003 : 00:06:00
|
| I recently moved from Access to MSSQL using the directions in the thread noted above by OneWayMule and it worked flawlessly. |
Edited by - chad on 06 December 2003 00:06:25 |
 |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 December 2003 : 14:44:44
|
quote:
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.
Where is that? I can enable Identity Insert, but I can't find here to delete existing data? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 December 2003 : 19:21:51
|
Ah, I could've realized that!
Thanks Rui, it worked great :) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ArtGoddess
Starting Member
Spain
19 Posts |
Posted - 21 February 2004 : 13:01:38
|
Hello!
I'm trying to migrate from Access to MSSQL and I have read everything you have post but I have some questions:
1) What does DTS mean?
2) For transferring information from Access to MSSQL do I need any extra program installed on my computer or in my server? Is it necessary to install any other server than IIS? Is it necessary to work with access?
3) Can I migrate with my actual Access database or first I have to create a blank one and then transfer all data?
And the last question. Not only I want to migrate to MSSQL, but I need to create a second forum using my actual database. I have read the process and I understand everything but... what do you recommend: migrate first to MSSQL or adding more tables to my access database first in order to support this second forum? Which process must I do first?
Thanks in advance!
PD: I have full access to the server: Micrososft Windows 200 server with IIS5. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 February 2004 : 17:31:35
|
1. Sorry to say it, but if you don't know what DTS is, maybe you shouldn't try it. DTS is Data Transformation Services, a tool that comes with SQL Server.
2. You need DTS.
3. Read the link posted by OneWayMule. The instructions in it are clear about this.
4. Migrate and then create the 2nd forum. It's much easier to do it with SQL Server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
