| Author |
 Topic  |
|
|
yugi
Starting Member
15 Posts |
 Posted - 24 July 2002 : 20:48:05
|
My server supports both SQL Server and MS Access.
I decided to change my Database from MS Access to SQL Server. To make my work easier, I've installed SQL Server 2000 Enterprise on my PC. (So I can easily convert from (.mdb) to SQL Server database on my PC)
But my server supports only 4 task for SQL Server:
+ Create : only type in databasename, loginname, password, databasepath (on server)
+ Delete
+ Backup : save to a file on server
+ Restore : load from a file on server
Now, what should me do?
Maybe:
1. Download MS Access file
2. Convert to MS SQL Server database on PC
3. Generate SQL script on PC
4. Upload SQL script file (.sql) to Server
5. Execute SQL script on server <-------- teach me how to do this with ASP.
6. Make a backup on PC, Upload it to server
7. On Server, choose restore, select the backup file I've uploaded
???
Edited by - yugi on 24 July 2002 20:49:25 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 21:00:18
|
quote:
But my server supports only 4 task for SQL Server:
+ Create : only type in databasename, loginname, password, databasepath (on server)
+ Delete
+ Backup : save to a file on server
+ Restore : load from a file on server
What do you mean? You cannot execute a script that will create the tables in your database?
quote:
Maybe:
1. Download MS Access file
2. Convert to MS SQL Server database on PC
3. Generate SQL script on PC
4. Upload SQL script file (.sql) to Server
5. Execute SQL script on server <-------- teach me how to do this with ASP.
6. Make a backup on PC, Upload it to server
7. On Server, choose restore, select the backup file I've uploaded
I don't understand why would you create a script on the PC, upload it to your server, execute it and then, at the end, restore a database on that same server. What was the initial script for anyway?
Snitz can be installed directly on a SQL Server database. Here is how to do it:
1. Create, or have your host create a blank database for you.
2. Run setup.asp?RC=5 to create the Snitz base tables in the database.
Now if you want to use your existing Access data in this database, then:
3. If you have mods installed, run mod setup for each of your mods, so that the necessary changes and additions are done in the database.
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.
For this last step you'll need to use SQL Server's Enterprise Manager or have someone who does it for you (maybe your host, but make sure the settings I described here are used).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
yugi
Starting Member
15 Posts |
Posted - 24 July 2002 : 21:53:03
|
quote:
quote:
But my server supports only 4 task for SQL Server:
+ Create : only type in databasename, loginname, password, databasepath (on server)
+ Delete
+ Backup : save to a file on server
+ Restore : load from a file on server
What do you mean? You cannot execute a script that will create the tables in your database?
YES, I can't excecute a script!!
quote:
2. Run setup.asp?RC=5 to create the Snitz base tables in the database.
3. If you have mods installed, run mod setup for each of your mods, so that the necessary changes and additions are done in the database.
Hic, poor me!! Some Mod I've written for my own, but now I lost their DB setup.
Is there any ASP Tools can execute a script? (admin_mod_dbsetup.asp can translate Mod syntax to sql syntax, so may be other .asp can translate from script syntax to sql syntax). I finally have a script file.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 21:57:34
|
quote:
Hic, poor me!! Some Mod I've written for my own, but now I lost their DB setup.
Is there any ASP Tools can execute a script? (admin_mod_dbsetup.asp can translate Mod syntax to sql syntax, so may be other .asp can translate from script syntax to sql syntax). I finally have a script file.
Script, you mean a sql script or an asp script? Is this getting confusing or what? I'm getting lost here...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
yugi
Starting Member
15 Posts |
Posted - 24 July 2002 : 22:01:45
|
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.
For this last step you'll need to use SQL Server's Enterprise Manager or have someone who does it for you (maybe your host, but make sure the settings I described here are used).
Hey, DTS is very powerful, I had my SQL server database (converted) on PC now. Can I export it to server immediately without step2 & step3?
Edited by - yugi on 24 July 2002 22:04:50 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 22:10:49
|
quote:
Hey, DTS is very powerful, I had my SQL server database (converted) on PC now. Can I export it to server immediately without step2 & step3?
What do you mean converted. If that's what I think, no you cannot, unless you want to mess your forum up. Tell me what converted means. What did you do?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
yugi
Starting Member
15 Posts |
Posted - 24 July 2002 : 23:38:02
|
quote:
What do you mean converted. If that's what I think, no you cannot, unless you want to mess your forum up. Tell me what converted means. What did you do?
Oh, converted: I converted Access DB to SQL Server DB
My steps will be:
1. Create a blank SQL Server Database
2. Use DTS to Export my DB on PC to that blank DB on Server
3. On DTS Wizard, choose "Copy objects and data between SQL Server Databases"
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
yugi
Starting Member
15 Posts |
Posted - 26 July 2002 : 02:52:16
|
quote:
So is it working now? The forum I mean?
I don't know... poor me! My server currently doesn't have a SQL Server Name. What the hell hosting service team do!!
But on my PC, I tried that solution, and my Forums still works normally. I'll test for a week. Then, I'll tell you the result soon.
At all, is there any wrong (not safe) in my steps?
1. Close my Forums on server (just rename config.asp --> bak_config.asp)
2. Download MS Access database to my PC
3. Use DTS to Export .mdb file to a new SQL Server DB
4. Test Forums on my PC (Win2k Pro, IIS 5, SQL Server 2000)
5. Create a blank DB on Server
6. Use DTS to transfer data from my SQL Server DB on PC to that blank DB (choose "copy objects..." to make sure that it'll copy all)
7. Restore config.asp with new strConnString points to my new SQL Server DB on server.
Edited by - yugi on 26 July 2002 03:07:33 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 July 2002 : 04:10:58
|
quote:
At all, is there any wrong (not safe) in my steps?
1. Close my Forums on server (just rename config.asp --> bak_config.asp)
2. Download MS Access database to my PC
3. Use DTS to Export .mdb file to a new SQL Server DB
4. Test Forums on my PC (Win2k Pro, IIS 5, SQL Server 2000)
5. Create a blank DB on Server
6. Use DTS to transfer data from my SQL Server DB on PC to that blank DB (choose "copy objects..." to make sure that it'll copy all)
7. Restore config.asp with new strConnString points to my new SQL Server DB on server.
You just need to make sure that between steps 2 -> 3 and 5 -> 6 you run setup.asp?RC=5 to create the SQL DB server structure correctly.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
