Moving DBs To 2000 From 7.0

May 4, 2001

What is the easiest way to move a db of 100GB from 7.0 to sql2000?
any ideas

Rani

View 3 Replies


ADVERTISEMENT

Moving Db To 2000

May 4, 2001

Is there any easiest way to move a 100 Gig sql 7.0 database to sql2000?

View 1 Replies View Related

Moving A 2000 Database To 7.0

Aug 9, 2001

We have developed our database in 2000. We want to run this DB on 7.0 But we get a bunch of errors. (we are not using any 2000 specific features).

Can anyone tell me way to export a database on 2000 to 7.0 ?

View 1 Replies View Related

Moving 2000 To 2005 Box

Mar 7, 2008

Hey guys I need to move a 2000DB to a 2005 just the database and the logins
Any suggestions of the best way to do this....
DTS backup attach database
Use the Upgrade Advisor....

View 1 Replies View Related

Moving Database To MSDE 2000

Dec 20, 2003

I have detached my database from the server and copied the mdf and ldf files to the new PC do I need to do anything but attach it to the MSDE? What about logins, roles, etc... does all this remain the same or do I need to delete the old and reenter them?

Please provide any help, thank you.

View 1 Replies View Related

Moving SQL Server 2000 Master Db

Mar 6, 2006

Does anyone know how to move master db to a differetn drive instead of default c: drive in a named instance environment?
Thanks.

Rick

View 10 Replies View Related

Moving Users From 2000 To 2005

Oct 23, 2006

What is the best way to move users from a 2000 sql server to a 2005 server? I have a bunch of issues with the passwords etc...

thanks for your time.

View 5 Replies View Related

Moving SQL 2000 Server To A New Machine

Jun 24, 2002

I am moving my SQL 2000 Server from a Small Business Server to a full version of Windows 2000 Server and SQL 2000 Server. I have had no experience doing this but have backed up and restored my production databases for practice in case a of disaster situation. Is there anything special I need to do to move everything, including the system databases to a new server and not loose any of the user logons, etc.?

Thanks for any advice,
Chris

View 1 Replies View Related

Moving From Access To SQL Server 2000

Sep 26, 2001

Hi there everyone, I have written a database system which tracks the performance of working in a shipping company in access. Im now rewriting the system in sqlserver and the only real problem I have found so far is that its difficult to estimate what kind of a server *cpu* & *ram* would be appropraite. The system currently performs transaction on my desktop machine in a second a quickest and 2 at slowest.
There are going to be about 500 users in 3 time zones so there will only really be about 300 max hitting the system in an hour.
I was looking at a Dell Poweredge server with twin P3's and half a Gb or ram would this be a good place to start from?

Any Advice would be great!!!

Steve

View 1 Replies View Related

Moving DB From Sql Server 2000 To 2005

May 21, 2008

Hello, what is the easiest way to move a DB (tables and data) from SQL server 2000 to 2005.

Ive been trying to export the DB tables from 2000 using Excel, yet i get "cannot expand named range" errors on several of the tables.

Is excel the way to go? another way? Can i use backup/restore?

Note: also moving from one machine to another.


Thanks for any help.

View 2 Replies View Related

HELLLP !!! Moving From Sql 2000 To 2005

Mar 30, 2008

Hi ,

I am working on a DWH project, and we decided few days ago to move from 2000 to 2005.
we installed the 2005 on the same server with two different instances for testing the 2005.
I migrate everything with the indexes but the issue is that queries at the 2005 take much more time than the same query on the 2000.
for example i have a nasty qry which join 14 tables. at the 2000 its take around 2.5 - 3 mins and at the 2005 its infinity , they both have the same indexes.

PLS ANYONE HAVE ANY IDEA WHATS THE PROBLEM ?

View 14 Replies View Related

Moving From Accesss97 To SQL Server 2000

Jul 20, 2005

I have developed an Access 97 database that I would like to distribute to anumber of staff, but they do not have Access. At the same time I amconsidering upgrading to SBS 2003 premium edition which comes with SQLServer 2000.1. If we were to upgrade would it be a very difficult job to recreate thedatabase in SQL Server 2000, as in does it have wizards, macros etc.?2. Would the staff be able to use and share the new database from the serveror would they also require additional software on their desktops?3. Is there any way of distributing the Access 97 database with some sort of"run-time" licence - it was not developed using a developers edition?This has been posted to both comp.databases.ms-access andcomp.databases.ms-sqlserverYour advice would be appreciated.RegardsJohn McC

View 1 Replies View Related

Moving SQL Server 2000 Instances To A Cluster

Dec 10, 2006

Hi,

We have a new failover cluster (Windows 2003 SP1, Microsoft SQL 2000 SP4) with each node of the cluster hosting 7 SQL Server instances in a 2-node active-active configuration connected to a SAN. We are planning to move some SQL Server Instances(from existing stand-alone servers) into this Cluster. Any insight into the process of moving SQL Servers into the cluster would be highly appreciated.

Best Regards,
Himansu

View 4 Replies View Related

Moving Data From SQL 2005 To SQL 2000 Daily

Feb 21, 2007

We need to upgrade our HR system from SQL 2000 to SQL 2005. Support for SQL 2000 ends 12/31/2007.

We have a third party vender that do not currently support SQL 2005. Employee's data is transfered from our HR database to the third party database for the purpose of yearly performance evaluation on a daily basis.

Both databases are currenlty on a SQL 2000 server.

Can data be transferred from a SQL 2005 database to a SQL 2000 database?

View 4 Replies View Related

Moving CRM, SPS, Project Web Server, SQL 2000 To SQL 2005

May 17, 2007

I am reciving a new powerful database server



My old database server runs SQL 2000 and has the CRM 3.0 app and database, our corporate web site (SharePoint Services 3.0) database, and Project Server 2007 database. The corporate site and project apps and web sites reside on our file server.



I want to move, upgrade or migrate the databases, corporate site and Project site to this new SQL 2005 server. I am a little unsure the best way to do this.



Should I move all the database first, then move the apps?



Should I do a restore of everything on the new server, and after I know it works just turn off the other server?



Am I missing a better way?



Anyone have any insight, let me know.



Thanks,



Ken

View 1 Replies View Related

Moving A SQL Server 2000 Database That Is In Standby Mode

Jul 20, 2005

SQL Users/DBAs,I'm trying to move data files around for a database that is in standbymode. I can detach/attach the database fine usingSP_DETACH_DB/SP_ATTACH_DB , but when I re-attach the database the logsequence is broken and I can't restore any more logs. Does anyoneknow if there is a way to move around data files and keep the databasein standby mode?Thanks,JB

View 4 Replies View Related

Moving Sql 2000 DTS Packages To Sql 2005 Standard Edition

Feb 23, 2006

I have been tasked with upgrading around 150 SQL Server 2000 DTS packages to SSIS in SQL Server 2005 standard edition. I made a backup of the 2000 database upon which the DTS packages operate and restored it to the SQL 2005 server. So far, so good. I have the database in place. Now I need to get the DTS packages themselves into the SLQ 2005 server. I think I need to check my install and make sure that I have the SQL Server 2000 DTS services installed on the SQL 2005 server. I can do that.

However, I wonder what would be the most effective way to physically get the packages from the SQL 2000 server to the SQL 2005 server. Should I use structured storage files? If so, how do I go about opening them in SQL 2005 in order to save them to SQL server 2005?

I should mention that these packages make heavy use of ActiveX scripting so I am looking at rewriting them from scratch to be SSIS packages. I just need the packages on the SQL Server 2005 box so I can make sure I am creating exactly the same functionality in 2005 as existed in SQL server 2000. Each DTS 2000 individual package tends to be fairly simple and I think I can greatly improve the process by consolidating them.

Thanks in advance for any advice.

S. Wells

View 3 Replies View Related

Newbie Question, Moving Data Between Sql Server 2000 And 2005

Jun 7, 2006

Hi,

I'm a newbie on SSIS and am trying to grasp my way through this.



I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database.



What I want is to move the data to a staging table, then drop the main
table and rename the staging table to the main table, to minimize the
down-time of the data. I can't get the workflow to work, because the
staging table has to exist when I run the package. I thought I could
use an "Execute SQL" task to generate the table before I would run the
task, but that doesn't work. Am I going about this the wrong way? Is
there an optimal solution to this problem so my data can be accessible
as much as possible.



Regards,

Atli

View 5 Replies View Related

After Moving 2000 Databses To 2005 Error With Maintanance Plan

Oct 25, 2007



I have moved few databases in 2000 to a different server which run's on sql server 2005 and its not a instance ogf 2000.
I backed up databases in 2000 moved those files to other server and then restored them.
I had solved the problem of orphand users by deleting and adding again.

Now when i try to setup maintenance plan i have the following error after walking through the wizard

TITLE: Maintenance Plan Wizard Progress
------------------------------
Adding tasks to the maintenance plan failed.
------------------------------
ADDITIONAL INFORMATION:
Object reference not set to an instance of an object. (Microsoft.SqlServer.Management.MaintenancePlanWizard)
------------------------------
BUTTONS:
OK
------------------------------

what do i need to fix this????Any help is appreciated...

And what else do i need to make sure everything in 2005 are working fine apart from orphand user.

Please let me know

Thanks in advance

View 1 Replies View Related

Moving From 2000 To 2005: Issue Accessing Cursor Returned By Sp

Apr 28, 2006

I have a number of triggers that call a stored procedure that returns a cursor. The triggers then use the results of this cursor to do other actions.

My problem is that this works fine in SQL2000 but just won't work in SQL2005. When I try to access the results of the returned cursor, I get an error -2147217900 could not complete cursor operation because the set options have changed since the cursor was declared.

If I port the code contained in the sp into the trigger, it runs fine. But having to port over the sp's code defeats the whole concept of being able to re-use the sp.

Does anybody have any ideas of what could be going on?

I look forward to a quick response.

Dennis

View 8 Replies View Related

Moving Back To MSDE 2000 After Removing SQLServer 2005 Express

Sep 18, 2007

Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.

Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.

Any ideas on how to break the chain here are welcome.

View 1 Replies View Related

Error Connecting Database Problem After Moving Databases 2000 To 2005

Nov 9, 2007

I have moved my databases to 2000 to instance of 2005 on the same server.
Now i set databases offline in 2000 as i did upgrade use backup & recovery method.

& my connection string
Password=test;Persist Security Info=True;User ID=test;Initial Catalog=databasename;Data Source=ipaddress

i was using above connection string to connect when using 2000 databases form applications in the production machine

I get the following error when i am running my applications now after moving to 2005


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

IS it because i have two server on one server or
What do i need to do in order to fix this....tried several thing by searching nothing worked out..

Let me know
thanks


View 9 Replies View Related

Moving Data In Ssis From Sql Server 2000 To 2005 On Same Server

Feb 9, 2007

hi, does anyone know how I can make a connection to a 2000 db thru ssis?

View 8 Replies View Related

Transact SQL :: How To Get Moving Total Like Moving Average

Nov 10, 2015

I trying to get the moving total (juts as moving average). It always sum up the current record plus previous two records as well and grouped by EmpId.For example, attaching a image of excel calculation.

View 3 Replies View Related

Moving A SQL Server 2000 Database From One Server To Another Advice

May 23, 2006

Hi, i was after some advice on moving a SQL Server 2000 database from one server to another.

Usually i would do this by backing up the database on the original server the copying it accross the LAN to the new server and restoring it there. This database is 10Gb in size and copying it accross the LAN will take some time and i would like to minimise downtime if possible. The database is at a customer site where i am not responsible for the network or Hardware.

Thanks in advance for your help

Nick

View 4 Replies View Related

Moving SQL Servr 2000 From Windows 2K Server To Windows 2K3

Apr 17, 2008



Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition


Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition


Thank you,
Gish

View 4 Replies View Related

After Moving 2000 Database To 2005 Database

Oct 15, 2007



I have used backup and restore method to upgrage 2000 databases to 2005 database.
What do i need to do in order to for my application or users to use databse in 2005 and remove 2000

let me know
thanjs

View 3 Replies View Related

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

Moving An Sql Server 2005 Database To A Sql Server 2000 Database

Dec 12, 2006

I am trying to move a database which I wrote in SQL Server 2005 to a SQL Server 2000 database.
I'm not sure the best way to do this.......
Can anyone enlighten me?.....
 

View 4 Replies View Related

Moving ALL DB's

Jun 28, 2000

does anyone have a script that will read the sysdatabase table and transfer all datbase's to another server. example pseudo code:


start loop
get local sserver db name
create db on other server
transfer ALL objects to new database



end loop

View 9 Replies View Related

Moving SQL From C: To D:

May 29, 2002

I have inherited an SQL server that is running out of disk space. SQL 2000 was installed on a regretfully small C: partition, and I need to move as much as I can to the D: partition. I really don't want to uninstall and start over, and I am hoping there is a whitepaper or something that I can use to accomplish the same thing.

Any help is appreciated!

View 2 Replies View Related

Moving DB From X64 To X86

Apr 26, 2007

My company recently purchased a new ERP system which does not support 64 bit SQL Server. For this reason, I need to uninstall the 64 bit SQL server 2005 and install the 32 bit version. This leads to my question. I have an application currently using a database on the 64 bit version and would like to confirm that the DB will work correctly in the 32 bit version. Do I just have to detach the database, copy the files, then install SQL server 2005 32 bit and attach the DB?

View 4 Replies View Related

HELP MS Access Moving To SQL And Don't Know How

Oct 6, 2006

I have been using MS Access for a long time.  The last couple of months my sites have really picked up in business (good rankings) and we keep crashing the server (No sites on the server that use MS Access will run)  We get the errorSystem.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider()at System.Data.OleDb.OleDbConnection.Open()at DreamweaverCtrls.DataSet.DoInit()Also I am finding out from some of my customers that their sites they can't use at times because of the error but the server hasn't crashed yet because others are up.  Well I believe we are exceeding MS Access very badly because it crashes the server daily now and sometimes more then once a day. So I am going to start moving my MS Access database to SQL but have NO CLUE how where to start etc or use SQL correctly.  If people can point me in the right direction that would be very helpful.  Everything I find online is people needing help but no solutions that work for me.  My new server is a windows server running ASP.Net 2.0 and to edit my SQL I have "ASP.Net Enterprise Manager" and Plesk for the server.1. A good book to follow and easy to follow for SQL (connections / how tos) or website2. Good examples or book on "ASP.Net Enterprise Manager"3. How to convert access databases into SQL easy (some have over 50,000 listings)4. how to convert Tab files into SQL easy.Thank you so much for any help.  Also I am using Dreamweaver for most of the edditing and connections.  I know its not your favorite but I don't have the time to write everything by hand and it works good for what I do on the websites.Thanks again,Rusty

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved