MS Access, MS SQL Express, MS SQL when you should use wich version?
I'm planning to make a website for a in first part a small user group. There needs to displayed some data in the database.But because the hostings party advices Acces.I like MS SQL Express more, because the size of the visitors is getting very big. The meaning of the project is to make a big website for the complete country. But i can use Access, it works, but does anyone know till how much visitors you can use access, and MS SQL Express ?Of course MS SQL is very nice, but its also very heavy to get a licence.The website is made for free and we need to run it in spare time, also for...MS Access SQL migration to MS SQL Server TSQL
got some MS Access SQL Code that needs converting into TSQL:
Uncompleted, Count(dbo_MyServiceRequests.pkServiceID) AS TotalCount
FROM dbo_qryMyServices LEFT JOIN dbo_MyServiceRequests ON dbo_qryMyServices.FormsServiceID = dbo_MyServiceRequests.PostType
GROUP BY dbo_qryMyServices.FormsServiceID, dbo_qryMyServices.ServiceName
ORDER BY dbo_qryMyServices.ServiceName;
because it's Access and got V...Problem with stored proc, migrating from MS SQL 2000 to MS SQL 2005
I've been migrating some DB from MS SQL 2000 to MS SQL 2005 all works fine but I have one problem with stored procedures.
Even if there is actually no errors I get the message "The transaction ended in the trigger. The batch has been aborted.".
The record is succesfully deleted but still I get the message above. I know MS SQL 2005 added the try/catch block did they change something else that cause compatibility issues with 2000?
Here's a sample : *** DECLARE @Error bit
DECLARE @ErrorMsg varchar (100)
DECLARE @ContactIDToDelete int
SELECT @ContactIDToDelete ...FYI - Interesting difference between Oracle SQL and MS SQL
While converting some code from T-SQL to PL/SQL, I ran across an interesting bit of MS SQL code. The code looked odd to me so I did a quick experiment to prove what it did. I was quite surprised by the MS SQL results!
create table testunion (aaa number);
insert into testunionselect 2 from dualunion select aaa * aaa from testunion;
select * from testunion; -- Returns one record, as it should, "2"
insert into testunionselect 2 from dualunion allselect aaa * aaa from testunion;
select * from testunion; -- Returns one record, ...MS SQL 2005 Locking problem with direct SQL
I am using IDM 3.5.1 connecting to a MS 2005 SQL Database with the JDBC
1.2 Third party drivers.
On the command trnsform channel I have the following rules. My problem
I can do UPDATE and INSERT commands BEFORE the current operation, i.e. I
can add a record using the /nds/input/ instead of AFTER the current
operation using ../ as in the rules below.
However when I use th ../ as below it seems as if the table is being
held open after the update (or insert), as you can not access it unles
you restart the SQL server service, where the update and insert have...MS-SQL 7 to MS-SQL 2000
With Enterprise Manager, how can I convert a database from MS-SQL 7 to MS-SQL 2000
Do you have Books Online? There is a topic in there called "Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)" which will tell you how to do it.
Terri MortonEngagement Manager, NeudesicHow to ask a question
Create a staging database to deal with issues before moving to the destination database. We still have some 7.0 and 2000 running. The process is test a lot then deploy. Hope this helps.
Gift PeddieKind regards,Gift Peddie
thanks guys...MS access TO SQL SERVER Problem
I always used MS Access Database In my programs, now I want to use SQL SERVER database and so I started to design one. but it’s a little bit confusing ,I don’t know what can I use in change of these access Data type :
MS access // SQL SERVER
Memo >>>>>>>> ??
AutoNumber >>>>> ??
* and if you think there is some difference between Ms access and SQL in D...Problem with MS SQL vs. Access database
In my office we have PB with MS SQL 7.0, but would like to put up a home
development system with a small Access 97 database, with the same
tables. Our Access ODBC driver is version 4.00.3711.08. The two
things that seem to be creating a problem are "SubString and Join".
Would Access 2000 make a difference. Not real experienced with this
program, so I don't know if any of this I'm asking about makes a whole
lot of sense. Thanks for your help. Wayne
Wayne N. Gelineau, Database ...converting sql to MS SQL
I'm trying to unload a SQL Anywhere database to a MS SQL 6.5 database.
SQL produced from SQL Anywhere is not at all compatible. Is there an easy
way of moving a database from SQLA to MS SQL
Look at PowerDesigner from Powersoft. I can reverse engineer SQLA and create
the MSSQL Server DDL for you.
Sybase Professional Services
Darrell Fuller wrote:
> I'm trying to unload a SQL Anywhere database to a MS SQL 6.5 database.
> SQL produced from SQL Anywhere is not at all compatible. Is there an easy
> way of moving...Paging records in SQL Server 2005, SQL Server 2000, MS Access and MySQL
As a Web developer, you should know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView is NOT recommended, simply because with every roundtrip to the data-server, you get ALL the records ALL of the time. This is fine perhaps for very small databases (the kind, say, a Microsoft programmer would use to develop a new feature), but in the real, ugly world outside, databases tend to have tables with several tenthousands of records.
Hence the need for custom paging in a WebControl.
Custom paging poses 2 problems :
How to get a page of re...Re: Problems Creating SQL for MS-Access from PDM
When attempting to run the creation VB script generated by
PowerDesigner I receive SQL error: "Compile Error: Expected
end of statement"
My first lines of SQL Code are:
Option Compare Database
CreateTble C=ADP_CLAIMS N="ADP Claims";
What am I doing improperly?
It sounds like you generated a script for ms access from your physical data
model. This is not at all a script you can run in vbs window.
This is usable with the tool you can find in "Tools" subdirectory of your
PowerDesigner installation path.
A tools.txt file may help you to find th...problems migrating from MS Access to SQL Anywhere / ASA
Hello, I was able to migrate MS Access Data to SQL Anywhere using the
migration tool but I am having the following problems with an Access
front-end form having 3 subforms. The main form is linked to a "parent"
table and the 3 subforms are linked to 3 "child" tables:
1. on 2 of the subforms, I can add rows but cannot modify data in those
rows after they've been added. I get a message in a message box titled
"Write Conflict" saying "This record has been changed by another user since
you started editing it. If you save the record, you wil...MySql Or MS Access or MS Sql
I want to know, that is MS Access or MySql more efficient and why. And i have a confusion.. is MySql db server a free server or we have to buy it to use.
As i think implementing MS Sql server will cost me more, which one of the above is a better solution in that case.
imran.U and I Solutions,http://www.uandisolutions.com
MySql would be ideal for you since MS Access doesn't provide all the flexibilities of relation database.
Mysql can be downloaded from this <a href="http://dev.mysql.com/downloads">Link<a/>
Hope it helps.
Thanks....from MS Access to MS SQL help!
hi there, i have a website that runs off of MS access, but i feel its time it is out growing it, so i want to move everything to MS SQL, how can i convert my DB (there is about 18 tables, data is not important) and then can i just switch over my data sources on my pages by adding in a line or two of code or do they all require re doing?
JezJeremy HusonSenior Network EngineerCarden Computers - PC Repair Brighton
Give the new Microsoft SQL Server Migration Assistant for Access a spin: