Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server or Oracle 1
- Thread starter simco
- Start date
- Thread starter
- #3
i'm not sure what you mean by 'merge' but access can be used with sql server - either as a front end with linked tables or as a legacy system that is completely converted. sql does not have the same front end capabilities as access (ex: forms) - its usually coupled with a front end written in something like visual basic but you can easily use access for this purpose if you have existing code that you do not want to re-write.
MinAmiChief
Technical User
There is some documentation on the Oracle Tec net website.
I think that Oracle has a lot less gui but it has very good free documentation and has some powerful features that SQL doesn't seem to have. The reason is Microsoft sells its front apps or data access to Excel what ever in the form of VB.
I am definetly not an expert but I think if you want a serious database Oracle would be better (as you can tune it more with dbo like table_space etc). However sying all of that I think SQL Server is still a very good package and the difference isn't much for the average developer.
as an example
Oracle SQL Loader v's DTS on SQL
SQL Loader
No Giu yet still very easy to understand and use. Proides good logging for errors etc.
DTS
lots of GUI. Click this selected that. I could find the functionality for building a query on import but it was a little hidden behind the other buttons.
Conclusion:
I am using SQL Loader as it seems faster to learn than Oracle. Also we have a lot of Access Dbs that are too big. Someone made the decsion to go with SQL Server as the backend for these Access Db's and gave me the job. hence I'm happy.
Hope this helps.
I think that Oracle has a lot less gui but it has very good free documentation and has some powerful features that SQL doesn't seem to have. The reason is Microsoft sells its front apps or data access to Excel what ever in the form of VB.
I am definetly not an expert but I think if you want a serious database Oracle would be better (as you can tune it more with dbo like table_space etc). However sying all of that I think SQL Server is still a very good package and the difference isn't much for the average developer.
as an example
Oracle SQL Loader v's DTS on SQL
SQL Loader
No Giu yet still very easy to understand and use. Proides good logging for errors etc.
DTS
lots of GUI. Click this selected that. I could find the functionality for building a query on import but it was a little hidden behind the other buttons.
Conclusion:
I am using SQL Loader as it seems faster to learn than Oracle. Also we have a lot of Access Dbs that are too big. Someone made the decsion to go with SQL Server as the backend for these Access Db's and gave me the job. hence I'm happy.
Hope this helps.
- Thread starter
- #6
Thank you both! Is really helping me.
If we decide to do the same thing: go with an SQL server as the backend for Access DB's, what kind of SQL Serverd do I need? So far I have all the db's in Access '97. Is Access 2000 working better with SQL Server?
If we decide to do the same thing: go with an SQL server as the backend for Access DB's, what kind of SQL Serverd do I need? So far I have all the db's in Access '97. Is Access 2000 working better with SQL Server?
-
1
- #8
You can no longer purchase SQL Server 7.0 so you'll have to buy SQL Server 2000. SQL Server Standard Edition supports up to 25 users and costs $1495 for 5 client access licenses. Each additionas CAL costs $165. If you require more than 25 concurrent users to your server, then you need to get the Enterprise version, which you can buy for $4999 for the processor license. Access 2000 is a much better option for a front end than Access 97 because you can create an Access Data Project which automatically links to the SQL Server data engine and you can implement security, create tables, views within Access without having to go to SQL Server Enterprise Manager. Plus you can use an upsizing wizard within Access 2000 to upsize your application to SQL if you don't want to use the Data Project method. The problem with this approach is that you would still be using the Jet database engine instead of the the SQL Server database engine. Stick with the Data Project method.
hi, is there a way to install Microsoft SQL server once and change the computer name of the server after the installation of SQL Server. I'm receiving an error that SQL server installation was corrupted and the only solution I got is to re-install SQL Server. It is a tedious process since I have to restore my previous database after re-installing.
hey redshadow,
first go to the sql server installation folder and COPY all the contents of its data folder into another drive or folder.
Then uninstall and re-install SQL Server.
And stop the service of SQL server from the service Manager, and then copy all the contents of the previous data folder onto the new data folder, under the new SQL Server instlallation folder. then re-start the service again. Lo and behhold! your originaal databases and table are there as it is.
But if there is a corruption you say, then what exactly is the problem ?
RENAMING the SERVER NAME MAY NOT EXACTLY BE THE SOLUTION. It depends on ur problem..
Mail me with your problem detailed at cdhruva@usa.net , and I will give you the best and fastest possible solution.
Regards
SlyFox
first go to the sql server installation folder and COPY all the contents of its data folder into another drive or folder.
Then uninstall and re-install SQL Server.
And stop the service of SQL server from the service Manager, and then copy all the contents of the previous data folder onto the new data folder, under the new SQL Server instlallation folder. then re-start the service again. Lo and behhold! your originaal databases and table are there as it is.
But if there is a corruption you say, then what exactly is the problem ?
RENAMING the SERVER NAME MAY NOT EXACTLY BE THE SOLUTION. It depends on ur problem..
Mail me with your problem detailed at cdhruva@usa.net , and I will give you the best and fastest possible solution.
Regards
SlyFox
SQL Server does not have a front end at all.
So if you develope an application to use it, you have to do it Access or Visual Basic or C or something.
I use it alot and like it. It does have a nice gui to help in creating users and permisions. Tables and so forth
You can also use it with WEB sites. if you can create .ASP pages.
So you can have one database (or more) that can be accessed anywhere in the world. From the Office from Palm Pilots from ... DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
So if you develope an application to use it, you have to do it Access or Visual Basic or C or something.
I use it alot and like it. It does have a nice gui to help in creating users and permisions. Tables and so forth
You can also use it with WEB sites. if you can create .ASP pages.
So you can have one database (or more) that can be accessed anywhere in the world. From the Office from Palm Pilots from ... DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Status
Similar threads
- Locked
- Question
