Why Upgrade To MS SQL Server (be It 2000 Or 2005) From Access (say, 97)?

Dec 1, 2005

Probably this question has been asked hundreds of times and yet net
search has not generated satisfactory enough answer, at least, to me.
And OK, let's assume your organization has more than 200 employees,
just one measure to indicate that it's not small and data processing
needs are quite extensive (for both OLTP and OLAP).

We've heard so much about concurrency support, stability and
performance. Are there any real persuasive paper out there to talk
about it? Now, let me also put it in another perspective, say, you're
a Microsoft sql server sales guy or gal for that matter for new
accounts. What you got?

Thanks.

View 5 Replies

Should I Keep Using MS Access 2000 Or Upgrade It To SQL Server?

Jul 12, 2006

Hi

I would like to get some advise on the capacity of concurrent users on Access 2000. Here is my situation:

- I have a vb6 application that connects to one database(currently is a access 2000 mdb) via Adodc .

- There will be 6-8 copies of this application running on different PCs and that database is shared .

- All 6 PCs read/write to that database concurrently.

I wonder would Access 2000 be a reliable choice?

Thanks for your time

View 5 Replies View Related

What Is Your Strategy For Upgrade An Access Db To SQL Server 2000?

Jun 22, 2006

This question probably has been asked many a time. And yet I feel itis still relevant for one thing a search on this NG does not produce adesirable answer.It is kind of disappointing that MS would not be able to transfer ERrelationship from an Access db to a SQL Server 7/2000-based one, theupgraded db/imported tables sitting on the SQL Server would not havePKs, say, you have 100 user tables, you have to first recreate PKs foreach of them then set up relationship between/among them, quite timeconsuming. Do you have a better way?Along the same line of the task, what options out there for convertingAccess Modules into SQL Server-based Stored Procedures and/or UDFs?The manual option is sure there, third party tool? I wouldn't trustthem that much though.TIA.

View 6 Replies View Related

Access Denied To SQL Server 2000 After The OS Upgrade To W2003

Jan 23, 2004

I cannot connect to the remote SQL Server 2000 running on this machine that has just been upgraded to the W2003 server. Everything worked perfectly before the upgrade on W2000. All the logins, firewall setting stayed the same. Can ping the machine.
But when trying to register/link, or connect thru ODBC, I got the error
SQL server does not exist or access denied.
We don't have SQL server SP3 installed.

ola

View 2 Replies View Related

Upgrade Query From Access To Sql Server 2005

Apr 6, 2006

I'm currently upgrading from Access to Sql Server, and I have a broken query that I cannot find a fix for.

The original query:

SELECT DISTINCT DownloadedNames.*FROM DownloadedSkims INNER JOIN (DownloadedNames INNER JOIN DownloadedInfo ON DownloadedNames.DNID = DownloadedInfo.DIDnID) ON DownloadedSkims.DM_ID = DownloadedInfo.DI_DM_IDWHERE DM_ID=23 AND (dWeek BETWEEN '6/26/2006' AND '9/18/2006')ORDER BY DIID, dWeek

I get the error "Msg 145, Level 15, State 1, Line 2
ORDER BY items must appear in the select list if SELECT DISTINCT is specified" when I test the query.

If anyone knows what changes I can make to the query, you'd really be helping me out.

Chris

View 1 Replies View Related

Sql Server Upgrade From 2000 To 2005

Jan 31, 2006

I am currently using sql server 2000 and I have just installed sql server 2005 in a separate box that will be used as the production server so I will be upgrading to the new database server soon.

I was reading the upgrade options for this situation and one option is to detach the 2000 database, copy the mdf and log files to the new server and attach it to mssql 2005. Another option is to recreate the tables, views, etc. and export/import the data to the new server.

I would like to ask what the best option is for this situation because I am not sure what the advantages and disadvantages of just detaching/attaching and recreating the database in sql server 2005. If I just detach/attach the database, will there be any disadvantage in the performance because the database files were created in 2000 and is functioning because of backward compatibility in 2005? Would it be better to recreate the database in 2005 and import the data from 2000 so that the database would be running in a way that is designed for 2005?

I am not really sure of the differences of these upgrade options so any ideas would be greatly appreciated.

Thanks in Advance

-Voltaire

View 7 Replies View Related

SQL Server 2005 Installation Or Upgrade From 2000

Jul 19, 2006

Hello, I have sql server 2000 personal edition on my PC and I have just got a 2005 DVD. I tried to install it but it is not working. I don't know how to manage my databases. As if there is no graphical managemnt tool. The 2005 is also Personal edition.
I reinstalled the sql 2000, and now I'm trying t upgrade to sql 2005, but still don't know how to do that.
Please someone help me!!!!!!!!!!

View 1 Replies View Related

Sql Server 2000 Upgrade To 2005 Blocked

Mar 4, 2008

I've inherited 6 sql server 2000 boxes. I've upgrade 3 with no trouble. now I have one that gives the message :
"your upgrade is blocked because of cross-language compatibility rules.
For more information about cross-language support, see the version..."

all servers are 2003, sp2. All SQL is Enterprise edition, default language is "english". even the collation order is
the same. why the cross language message? Any help would be good else I'll be forced to rebuild the DB and load application again. ugly!!

dave

View 3 Replies View Related

SQL 2005 Express Upgrade To SQL 2000 Server

Aug 20, 2007

Hi all,

My question might be a little bit unusual, but is it possible to upgrade SQL 2005 Express (the free version of SQL) to SQL 2000 Server without any loss of functionality?

Where do I have to pay attention to when doing this?

Thanks in advance!

MMQ

View 1 Replies View Related

SQL Server 2000 To 2005 Replication Upgrade

Apr 17, 2008

Hi All,

Currently we use SQL 2K SP4 and snapshot replication with a Central Publisher with Remote Distributor toplogy.

I am looking to upgrade or migrate our SQL servers to SQL 2005 and was wondering what is the best way to do this for our replicated architecture?

Is the best way to run the SQL 2005 Upgrade on all 3 servers (publisher, distributor, subscriber) and should it automatically upgrade the servers including the replication components? Is there anything i should consider/watch out for when doing the upgrade and it involves replication (namely snapshot replication)?

Thanks in advance.

View 1 Replies View Related

Clustered SQL Server 2000 To 2005 Upgrade

Jun 12, 2007

I would like to upgrade a production active/passive SQL Server 2000 cluster to SQL Server 2005.

I've read all of the documentation I could find, and doing an in-place upgrade seems to be the way to go. (Despite the fact it scares the hell out of me.

But throughout all the documentation, I've yet to see some simple and fairly important questions answered.

How does the process of upgrading SQL Server work when you're dealing with a cluster?

Do you upgrade one machine then the other? If so, do you upgrade the active node first, or the passive node?

What happens if you're forced to failover from one instance to the other before you've had a chance to upgrade both to 2005? In other words, you failover from 2005 to 2000. Would that even work?

What happens if your upgrades fails for some reason? Is it easy to rollback the installation? If not, will reinstalling SQL Server 2000 cause any issues? Will it remember the previous configuration and simply fix the broken install?

Any help/insight would be greatly appreciated.

View 8 Replies View Related

SQL Server Upgrade 2000 - 2005 Files Read Only But Not Really

Feb 28, 2006

Hi,

I'm trying to upgrade from SQL Server 2000 to 2005. The problem I am having is that when I try to attach the existing db files I get a message that says "database cannot be upgraded because it is read only or has read only files...."

Thing is... there is no write protection on the files.

Can anyone advise me on how to overcome this problem so that I can attach the db, please?

Thank you

Robert

View 25 Replies View Related

Upgrade An Active Passive Sql Server 2000 Cluster To 2005

Aug 14, 2006

I have upgraded our test server and on non cluster production machine. My next server is a cluster and I don't have a test cluster server. Do I upgrade the active node and that is all or am I going to need to fail it over and upgrade the other node.

Also the prerequesite for the upgrade advisor is .net 2.0 I am going to up that on each server one at a time but I am only going to add the upgrade advisor to one node is that ok.

I read the SP1 documentation and it clearly states only patch the active node and do not patch the inactive nodes.

View 1 Replies View Related

Apparent Successful Upgrade To 2005 But Old (2000) SQL Server Remains

Mar 15, 2007

I used the SQL Server 2005 Upgrade Advisor to upgrade from SQL Server 2000 Enterprise to 2005 Standard. The only complaint I got concerned DTS packages, but I had none anyway. When I open SQL Server Management Studio, I can run queries, but they're against tables in the old 2000 databases. The SQL engine and Server agent are version version 8.0. Not surprising that new TSQL statements like 'BACKUP SERVICE MASTER KEY TO FILE' won't work.

Do I have to uninstall my previous version before upgrading?

Thanks.

View 3 Replies View Related

Upgrade From MSDE 2000 Release A To SQL Server 2005 Express

Jun 28, 2006

I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is installed with Mixed Mode and strong password to SQL Server 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon Information screen, if I select SQL Server Authentication Mode, it will give me this message:

SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade.

Thanks for any help.

View 1 Replies View Related

SQL Server 2000 To 2005 Upgrade (Database Users Logins)

Jul 6, 2007

Hi All,

I have just migrated couple of test databases

from SQL Server 2000 to 2005 (side by side).

I also migrated the server level logins using SSIS transfer logins task, available on SSIS 'Transfer logins', I selected all the databases that I have migrated so that I have all database users account in server logins (to avoid orphaned users); but I don't have all the database users in server logins, also the sys.sysusers doesn't have the database users, that I have moved to SQL 2005. Can anybody help?

Also do I need to back up the SQL Server 2000 database and restore it on SQL 2005? What impact this operation can have?

Thanks for your time..

Bidyut

View 5 Replies View Related

Can MSDE 2000 Upgrade To SQL Server 2005 Standard Edition Directly?

Jul 3, 2006

According to this http://msdn2.microsoft.com/en-us/library/ms143393(d=robot).aspx, it seems that it cannot. But is this a complete chart?

Thanks for any help,

Peter

View 5 Replies View Related

SQL Server 2000 Vs Sql Server 2005 Upgrade Problem Any Ideas?

May 14, 2007

In our application we use the ADODB.Recordset.

In SQL server 2000

If there was a view that joined 2 tables and I accessed the view the 2 ID fields in the view would still have the AutoIncrement attribute still set to true so that I knew those were Identity fields.

In SQL server 2005

I dont' know why but if you reference a View that has Identiy AutoInc fields in ADO it doesn't keep those properties.

Also for whatever reason we Set the ID field to 0 to let ourselves know its a new Record. SQL 2000 let it happen and assumed it to be null where as By Setting the ID to 0 in SQL 2005 causes it to blow up on me.

Is there some sort of setting in SQL that can make SQL 2005 work like SQL 2000 in these two instances...

View 1 Replies View Related

Best Method To Upgrade From SQL Server 2000 To SQL Server 2005

Nov 29, 2007

Hi.

We are going to upgrade one of our SQL Server 2000/Win200 instance to SQL Server 2005/Win2003. Currently, the SQL Server 2000 which contains about 30 database. This is my plan:

Install SQL Server 2005/Win2003 on a new instance
Backup SQL Server 2000 database instance (how do I back all 30 database at the same time?)

Then do a Restore from the SQL Server 2005 instanceIs this a good method or using the "Copy Database Wizard" is better method?

I'm new to this so please advice? Thanks!

View 14 Replies View Related

Upgrade From SQL Server 2000 To SQL Server 2005

Mar 5, 2008

Hello Gurus:

My database is running right now at SQL Server 2000 Enterprise Edition. We would like to upgrade it to SQL server 2005 Standard Edition.

Since this database was upgraded from MS Access 2000 to SQL server 2000. This database is accessed by a proprietary application. I don't know some of the details about this application.

There is one more issue with this database, replication was implemented earlier and now it is disabled.

I am thinking that to take a full backup from SQL server 2000 and restore it in SQL server 2005. What do you think?

Please let me know if you have any other idea.

I have another question for you. Right now replication is disabled and I restore SQL server 2000 database to SQL server 2005. Would there be any problem when we try to implement replication again?

Thanks in advance.

Regards,
Arunesh

View 1 Replies View Related

Access 2000 And SQL Server 2005

Jan 21, 2008

Is it possible to connect to Sql Server 2005 using an Access 2000 adp? Ikeep trying, but it doesn't want to accept my id, even though it is right.

View 2 Replies View Related

Using 2005 JDBC Driver To Access SQL Server 2000

Oct 5, 2006

Hi,

I'm using JDBC driver for Server 2005 (version 1.1.1501) to access Server 2000. I have no problems reading my data, but every update returns "Cursor is READ ONLY".

If I use driver for Server 2000 I have no problems. And I have no problems running the same program with 2005 driver against SQL Server Express.

Where should I start debugging?

Thank you,

View 1 Replies View Related

Best Way To Upgrade SQL 2000 To 2005

Dec 11, 2007

Hello,
I have a project where I have to upgrade SQL 2000 to 2005. When we are upgrading we are going to move to new server so server name will change. Most of our applications have a hard coded connection string. Applications are developed with Classic ASP, .NET 1.1 and 2.0 as well.
Now the question is what is the best way to do this? Changing all the connection string will be a very painful task as we have many applications.
Can anyone suggest a way where we can achieve this without changing all the connection strings?
Thanks in advance.
Tareq

View 5 Replies View Related

Upgrade From 2000 To 2005

Oct 24, 2007

what are some of the issues that we might face while upgrading from SQl 2000 to SQl 2005? Actually I have to create upgrade plan for path from MS 2000 to MS 2005.

Any suggestions will be appreciated.

Thanks

View 1 Replies View Related

How Do I Upgrade From SQL 2000 TO 2005?

Nov 27, 2007

Hi,

I was wondering if anyone could point me in the right direction for upgrading from SQL 2000 to SQL 2005?

I was under the impression that it was as easy as following an upgrade path after popping in the CD, but I realized it's not.

I'm a Systems Administrator who has installed both version in stand alone systems, but never tried an upgrade.

Thanks for your help.

View 2 Replies View Related

Upgrade From Sql 2000 To 2005

Feb 4, 2008

Hello,

I would like to upgrade sql server 2000 to sql 2005. So Can I install the sql server 2005 on the same server where sql 2000 is already running and then use the database upgrade wizard. Or should I install the sql server 2005 on a different server.

Thanks

View 5 Replies View Related

Sql 2000 To Sql 2005 Upgrade

Aug 9, 2006

I have a sql 2000/2005 side-by-side install on a single server. I right-click a sql 2000 database, select All Tasks, and the Copy Database to upgrade a sql 2000 database. In the "Copy Database Wizard" I see the message:

"To use the detach and attach method SQL Server Agent must run under an Integration Servicers Proxy account that can access the file system of both the source and destination servers."

1. What does that mean?

2. I decided to click "Finish" in the wizard, and the database copy seemed to work fine. Whaterver 1) means does, by default, the SQL Server Agent already run under this "Integration Services Proxy" account. (Rememberr the upgrade process did work).

TIA,

barkingdong

View 2 Replies View Related

Upgrade SQL 2000 To SQL 2005

Jul 17, 2007

Hey Guys,

Looking for some type of solution on this issue. I'm going from SQL2000 to SQL2005 and I run the upgrade advisory tool and all and I'm going through the procedures of getting our SQL server updated to SQL2005, when I attempt to run that analyzer to take a look at how well the migration will go. I get a timed out error message on the fallowing.

ORDERBYORDINALS
FTCATPROPITEMCOUNT
OLDSYSTEMTABLES
DROPSYSOBJ
HOSTIDRETURN
FTPROPS
QRYGOVCOSTLIMIT
FTCATALOGNAMERESTRICTION
SPCONFIGURE
INVALIDCHAR
OPENXMLWITH
XPAGENTPROXY
UPDATETEXT
SPHELPTRIGGERNEWCOL
DISKINIT
SYSPERFINFO
DEPRECATEDSP
OLDDBCC
ORDERBYALIAS

Exact error message and its always the same for each entry.
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

Any help in this are would be greatly appreciated, all other issues have been resolved I'm just stuck on this and I don't want to upgrade until the advisory tool gives me the ok to.....

Thanks in advance.

View 2 Replies View Related

Looking For SQL 2000 To SQL 2005 Upgrade

Oct 5, 2006

All,

I am looking for upgrading SQL 2000 databases to SQL 2005.Has anybody got a detailed plan /Documents for doing so?.

Thanks and Regards

Avijit Macker

View 3 Replies View Related

Upgrade SQL 2000 SBS To SQL 2005 64 Bit

Sep 23, 2006

I am in the beginning of upgrading a SQL 2000 DB on a Small business server to a 64 bit 2005 DB on a new box. Is my best method of upgrading to use the "copy" DB function in 2005? If so, what do I need to do to install the management tools on the 2000 box - since this is a 32 bit edition, and I have the 64 bit media?

View 1 Replies View Related

SQL 2000 To SQL 2005 Upgrade

Mar 7, 2008

I got a requirement to upgrade only One SQL 2000 to SQL 2005 server. i did check that there are only databases in this server along with Linked server. I am looking for a best practice document for SQL upgrade and any thoughts or experience any one has faced during upgrade.

Other question is what about if there is a DTS on the server. right now on this particular server there is no DTS but in coming weeks i may need to upgrade other server which is having DTS as well. I have worked alot on SSIS packages but want to see if DTS will be converted to SSIS packages or i will have to manually do it.

Thanks

View 3 Replies View Related

SQL Upgrade From 2000 To 2005

Apr 2, 2008

Hi,

We have 2 .net 1.1 applications using Microsoft SQL Server 2000 Enterprise Edition. To connect to database we are using nHibernate 0.6 for one application and Microsoft Enterprise Library Data Blocks Ver 1.0 in another.
We are planning to upgrade SQL servers of both applications to SQL 2005 Enterprise edition and retain .net 1.1 framework. Are nHibernate 0.6 and Microsoft Enterprise Library 1.0 data blocks compatible with the SQL 2005? Are any upgrades required for these as well?
We ran SQL upgrade advisor report on these applications, there weren't any changes to table/ stored procs suggested. Could that mean that the existing table design and stored procs are compatible with SQL 2005?

Thanks in Advance,
Abhijith Bharadwaj

View 1 Replies View Related

How To Upgrade DTS From 2000 To 2005

Mar 9, 2008

Hi all,

I just ran sql upgrade advisor and got the following message:
"You can use SQL Server 2005 tools to edit your existing DTS packages. However, upgrading or
uninstalling the last instance of SQL Server 2000 on a computer removes the components required
to support this feature. You can retain or restore these components by installing the special
Web download, ��SQL Server 2000 DTS Designer Components,�? from the Microsoft Download Center
before or after you upgrade or uninstall SQL Server 2000."

I do have several DTS packages in my sql server 2000 database. does that mean if I upgrade my current 2000 database to 2005, those dts will be gone. But I can download sql server 2000 dts deginer components on our new sql 2005 database server before I upgrade. Then when I restore my sql 2000 database on our new 2005 server, eveything would be OK? I am not sure if my understanding is correct.

My advisor is on my local computer and I am running analysis against a remote database(on our intranet),��SQL Server 2000 DTS Designer Components,�? should be intalled on my local computer or remote database server? what steps I should take in order to retain my dts package or transform it into something else?

can you shed light on me?

Thanks.
Betty

View 3 Replies View Related