| Author |
 Topic  |
|
yigal7
Junior Member
297 Posts |
 Posted - 06 February 2008 : 14:06:29
|
i convert my mdb file to ms sql and now
i have a file on my local HD.
how do i use it now on my forum?
thanx
yigal |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 February 2008 : 15:04:14
|
You might want to try one of the recommended procedures like this one:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884
There's another topic or ten along the same lines - nothing some quality time with "search" couldn't turn up.  |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 07 February 2008 : 19:33:59
|
| As Rui says, it's not just a case of importing tables, all of the supporting constraints etc need to be created too, by running setup.asp against your MSSQL Server DB on your web host (if they provide MSSQL), then importing the data. If you try following the instructions in Rui's linked page, you can always come back and ask again if you hit problems. :) |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 February 2008 : 21:19:18
|
Wow. I was just confused for Rui! I'm honored.  |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 09 February 2008 : 15:28:05
|
quote:
Originally posted by AnonJr
Wow. I was just confused for Rui! I'm honored.
Heh heh oops! You're both top geezers ;-) |
|
|
|
yigal7
Junior Member
297 Posts |
Posted - 10 February 2008 : 00:32:10
|
ive been told by my host to send them the file since
i dont have permision to do it.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 10 February 2008 : 09:35:51
|
| As long as you've followed the procedures to ensure you don't lose the appropriate check constraints, etc. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 February 2008 : 11:52:46
|
quote:
Originally posted by pdrg
Heh heh oops! You're both top geezers ;-)
But I'm not old enough to be a "geezer"! 
yigal7, as long as you used setup.asp to create the tables you shouldn't run into too many problems. Definitely check and re-check the default values, indexes, etc. because if they are off it will cause problems. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 10 February 2008 : 15:47:25
|
quote:
Originally posted by AnonJr
But I'm not old enough to be a "geezer"!
Don't worry, it's commonly used as a term of endearment over here :-) |
|
|
|
yigal7
Junior Member
297 Posts |
Posted - 11 February 2008 : 08:16:17
|
can u help? i got this mail from them.
---------------------------------------
ello
Thank you for the word to support.
I'm sorry, but could you please convert your database in to MS Tape format(.bak) and we will import it for you, as we do not importing database from the mdf format. Thanks.
Should you have any further questions, please feel free to contact us anytime, we are available 24/7.
Kind regards,
Alexander Karamushko
Technical Support
----------------------------------------------
don't know what they talking about.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 14 February 2008 : 13:10:04
|
Yep, this is another reason why it's good to go with the standard method. You'll have to go into your enterprise manager for MSSQL, select the db, and choose to back it up to a device, create a disk/file device as a .bak file and backup the db to that - then the host will restore that backup onto their server as a new db. It's beyond the scope of here to go into more detail, so either start learning about MSSQL Server, or try using the suggested workflow.
You could try asking your host to *attach* the .mdf file, but they say they don't, so they either don't understand how to (quite possible) or have other reasons for a standardised workflow.
If you haven't created the tables on the SQL Server using setup.asp, but have just used an 'upsize wizard' or something, it's unlikely to work anyway. This is why we don't suggest it, but suggest this instead. |
|
|
|
yigal7
Junior Member
297 Posts |
Posted - 04 March 2008 : 12:08:53
|
| but i did with enterprise managerlike it said and got the MDF file. |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 04 March 2008 : 12:31:14
|
you can't necessarily just attach an mdf file, depends on what users created it and have rights to it etc.
to create a .bak file just backup your database. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 04 March 2008 : 12:43:42
|
quote:
Originally posted by HuwR
you can't necessarily just attach an mdf file, depends on what users created it and have rights to it etc.
See me and my rustiness ;-) |
|
|
|
yigal7
Junior Member
297 Posts |
Posted - 04 March 2008 : 15:15:09
|
| Huwr-my forums is MDB file based how do i create a bak file? |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 04 March 2008 : 15:16:53
|
| you can't an mdb file is an access database not a sql database, the only way to get that into an mssql database is by using DTS (your host will have to do that) |
|
|
|
Topic |
|
Topic Locked
