| Author |
 Topic  |
|
|
prescottw
Junior Member
189 Posts |
 Posted - 07 November 2005 : 11:14:44
|
Hello my fellow Snitzlings!
I can't figure out how to D/Load my DB from my server. I want to keep it as an ACCESS on my computer.
Thank You!
-prescottw |
What day is it anyway? |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 07 November 2005 : 12:11:02
|
Helloooo!
You can
1) copy down the .mdf file after detaching it from SQL Server (but it'll still be a SQL Server db, so need SQL Server to run it
2) DTS it down to a local access db
3) try using 'get external data' in Access to reimport all the tables, then monkey around with them a bit
probably several other ways to go too, personally I'd do 2) if I really wanted it as an Access db, or 1) if I could run it locally in MSDE/SQL Server instead |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
prescottw
Junior Member
189 Posts |
Posted - 07 November 2005 : 15:12:56
|
BOTH actually.
OK, #2 worked perfectly. I used DTS Import/export data. (The utility that comes with EM).
I placed a new database on my desktop.
I imported all 63 tables.
Then I took the DB and put it up on a test site. Wait a second let me check something...
I'm checking installation.
OK perfect. The site works fine. Everthing seems to be dandy.
Now I'm just curius if I can use the upsizing wizard to get the database back up if I need to.
(Before I didn't have much luck using EM DTS to import my database to SQL server. I did NOT work for me).
Soo anyway... After reading a post where a host had changed to a different *faster* SQL server.
I started planning for a rainy day.
Anyway I am a little leary of putting up a DB that I just changed from SQL server to Access back up using the upsizing wizard in MSACCESS back to Sql Server at the moment. I might wait until nobody is on the site. Not that there is anyone on the site right now... let me check... WOW 1 person woohoo! Thought it was me (both windows 2000) but it was an actual person and not a bot!
See.
I'll wait till tomorrow morning.
pdrg... Thank You!
ruirib... Thank You!
-prescottw |
What day is it anyway? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 November 2005 : 16:01:44
|
| Whatever the migration direction SQL -> Access or Access -> you should have setup.asp create the DB structure. After that, using DTS with identity insert enabled and deleting any existing data, will work faultlessly. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
prescottw
Junior Member
189 Posts |
Posted - 07 November 2005 : 16:08:54
|
ruirib, thank you.
So that is just a few clicks and a check to complete in setup.asp is that correct? I'm not totally familiar with this as you probably detect.
-prescottw |
What day is it anyway? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 November 2005 : 16:16:55
|
If the SQL Server DB has been created and was working without issues, running setup.asp is not needed, the same being applied to the Access DB. Other than that, it's just as I wrote before.
Access to SQL Server: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31144
It applies to a SQL Server DB without the Snitz tables created. In your case, only the DTS recommendations should be followed, if I got you right about using the same SQL DB from which you originally imported to Access. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
prescottw
Junior Member
189 Posts |
Posted - 07 November 2005 : 16:41:25
|
I remember that post when I first read it. I thought it was hillarious. (still is) I think that I'm set as long as I keep an updated *back-up* of my DB.
Thanks again ruirib!
-prescottw |
What day is it anyway? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 08 November 2005 : 04:52:35
|
quote:
Originally posted by prescottw
pdrg... Thank You!
ruirib... Thank You!
-prescottw
You're welcome! |
|
|
| |
Topic |
|
Topic Locked
