| Author |
 Topic  |
|
snaayk
Senior Member
USA
1061 Posts |
 Posted - 02 December 2003 : 11:55:22
|
Moving from Access to MS SQL in the past has not always been an easy proposition. I've done it countless ways and have ended up running into one kink or another. Whether constraints are different, data was corrupted or missing, or just an error in the process - it hasn't been a "double-click" operation.
I would imagine moving from MSDE to MS SQL *might* be as easy as drag and drop - although I haven't looked into it. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 December 2003 : 12:16:48
|
| MSDE is MS SQL. With Enterprise Manager it could be just a matter of detaching the DB in one side and attaching in the other, or similar. Anyway, moving from Access to SQL is also easy, if you take the steps to recreate the DB structure before doing any actual transfer of data. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 02 December 2003 : 16:22:25
|
| Very very interesting. Looks like they just released this the end of October as well. I am going to set up a test site identical to mine and transfer my SQL database over and do some experimenting. This may be the answer to my problems of possibly needing to move off of MS SQL. |
Erick
Snowmobile Fanatics
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 02 December 2003 : 23:16:32
|
quote:
MSDE is MS SQL.
With some limitations and caveats like connection limits etc of course. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 03 December 2003 : 00:25:28
|
quote:
Originally posted by ruirib
MSDE is MS SQL. With Enterprise Manager it could be just a matter of detaching the DB in one side and attaching in the other, or similar. Anyway, moving from Access to SQL is also easy, if you take the steps to recreate the DB structure before doing any actual transfer of data.
Exactly! |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 03 December 2003 : 03:31:21
|
quote:
That MSDE is looking like an actual alternative to Access.
MSDE comes with Access!
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 December 2003 : 04:42:07
|
quote:
Originally posted by Doug G
quote:
That MSDE is looking like an actual alternative to Access.
MSDE comes with Access!
Now you can get it without even owning Access. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 03 December 2003 : 09:45:27
|
quote:
Originally posted by Doug G
quote:
That MSDE is looking like an actual alternative to Access.
MSDE comes with Access!
Yes, but now, with this version A (free SQL Server), it supports up to 25 concurrent users - whereas the old supported - what 5?.
For web site developement it would make sense to use MSDE and not Access - I wonder if the hosts will begin supporting it. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 03 December 2003 : 16:31:14
|
I was just trying to emphasize msde isn't an alternative, it's part of :)
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 03 December 2003 : 21:46:44
|
quote:
Originally posted by Doug G
I was just trying to emphasize msde isn't an alternative, it's part of :)
I see, but it is an alternative, since it can be downloaded and installed without Access and IMO seems better equipped for busier sites than Access. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 04 December 2003 : 01:35:24
|
I give up :)
I'll go off and watch Cool Hand Luke again now 
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 04 December 2003 : 12:14:23
|
| But what I'm trying to say is.... |
|
|
|
Topic |
|
Topic Locked
