I have just installed snitz using access and I am implementing mods I want 1 by 1. I want to test diffrent mods before choosing to use each addition. However I do want the final DB to be in MS SQL.
So my plan is to use access (because I am so familiar with it) while I am in this phase. I really need the forums to be live for registration of members.
Basically: I have a fairly clean Access Install live now.
I have a tesing forum with mods and another Access DB seperate from my live one.
What I want to do Is build the MS SQL DB that my hosts provides using each mod I keep from the testing forum. So the MS SQL version of the forums will look and behave the way I want minus all the member info that my live one is using. I am thinking I will have around 50 members when the MS SQL DB is ready in a few days (poor timing on my part).
So heres my question, when I am ready to add the members can I just copy the members table to MS SQL? Do I need to use import?
Does anyone know of a good MS SQL Database Management tool (maybe web based). I prefer not use enterprise manager, It is not offered by my host, and the expense of it is not practical at this point. I have sql management studio, but I really want something that works/looks more like access?
I would appreciate any suggestions or help!
**Update** Duh all my topics and categories will be lost huh? Full upgarde then?
You can transfer all the info you want from an Access database to a SQL Server database. This transfer is best done using Enterprise Manager / SQL Server Management Studio. Personally I know of no online tools to do this. Enterprise Manager / SQL Server Management Studio is the adequate tool to perform this.
In this very forum there are specific instructions on how to migrate an Access to a SQL Server database. Just follow them and you will be ablet to transfer all you need and just what you need.
Could you give me a quick rundown on what mods you think are vital. I want to have the basics running in access before I move to MS SQL, again just because I am more familiar with it.
Topic Locked
Posted - 01 February 2007 : 15:44:12
