Migrating SQL 2000 To A New Sever

Sep 20, 2006

I am upgrading our SQL 2000 Server hardware. I am looking for a way to "mirror" this server. The only items that we are changing are updating the hardware and the OS will be Server 2K3 instead of Server 2k

Does anyone have a reliable method, or suggested processes for migrating one server to another?

View 1 Replies


ADVERTISEMENT

SQL Sever 2000 And DB2

May 17, 2002

I have a situation where I might want to pull(select) some information from a DB2 database, and possibly push(insert) some data to the same DB2 database. I am sure this is being done in the real world. WHat software, infrastrucure, etc would I need to accomplish this. Is it as simple as using DTS and the proper drivers, or are their better products and solutions. ANy
input appreciated.

View 3 Replies View Related

SQL Sever 2000

Jun 6, 2004

Hi, I have installed SQL 2000 on my system and when I try to start it gives me an error saying 'ordinal 29 cant be found in the dynamic link library odbcbcp.dll.
Please advice!!

View 1 Replies View Related

MS SQl Sever 2000 Question

May 14, 2003

i need write a Feasibility report about MS SQL 2000
Easy of use?
Cost?
Development speed?
Features

View 1 Replies View Related

Reinstall SQL Sever 2000

Sep 22, 2004

Hi all,

I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.

Now is there a way to reinstall 2000 and just getting the files that the server is missing?

Is there any guidelines or steps for reinstalling 2000 out there?

Thanking you in advance.

Lystra

View 7 Replies View Related

Web Synchronization For SQL Sever 2000?

Dec 6, 2005

Knowing that web synchronization is a new feature comes with SQL Server 2005. 

View 1 Replies View Related

SQL Sever 2000 And 2005 On Same Machine

Nov 21, 2006

Hi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine.  I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict.  The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name).  I need to connect to a database on the HARDYSQL5 registration but I am not connecting.  I have tried various connection strings but none have worked.  I get a Login failure.  I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;"  I'm gon go nuts.  What am I doing wrong? Thanks. 

View 10 Replies View Related

HELP PLEASE!!: How To Connect To SQL Sever 2000 From Solaris?

Aug 11, 2005

We want to run Unix Scripts on SunSolaris which Connected to MS SQLServer 2000.We would like to connect to SQL Server 2000 from Solaris. Is there anyway to connect to Sql Server 2000 natively (just like isql we use inwindows which has the client) with the help of third party ct library?or any other drivers or tools???TIA

View 5 Replies View Related

SQL Sever 2000 To SQL Server 2005

Jul 27, 2006

Hi all,

I have an aplication in VB6 that uses an ODBC to link to a SQL database.

Until today all my clientes had SQL Server2000 and my aplication worked fine.

Some of my cliente have now SQL 2005 and my application still woks fine except in one of them.

In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column.

This column is data type BIT and my code is

...
Myrs("Servida")= true
...

Any idea why the error appens? And why only in a particular machine and not all of them with SQL2005?

What can I do? I changed the code for

myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want to change thousands of line of code where I read/write a column in the database data type BIT.

Is there a way to configure SQL Server 2005 the way that it controls data type BIT?



Regards

Luis

View 1 Replies View Related

View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager

Apr 25, 2006

Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"

Thanks

View 3 Replies View Related

MS SQL Sever 2000 String Connection Problem

Jun 17, 2004

Hi, i'm very new to Web Matrix. I've been following the C# end-end application tutorial exactly but i can't seem to run my application.
The code given in the link below is for MS Access but I'm using MS SQL 2000, so i'm not sure of the syntax for the code provided below (string connectionString...)
Please help..thank u!!

http://www.asp.net/webmatrix/guidedtour/section91/bookrequestcontrol.aspx


string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:TempProjectsLibraryDatabase.mdb";

public void LoadRequestedBooks(){



try

{



string mySelectQuery = string.Format("SELECT books.* from books, requests where books.bid = requests.bid and requests.mid = {0}", Session["userid"]);

System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);

System.Data.DataSet myDataSet = new System.Data.DataSet();

System.Data.OleDb.OleDbDataAdapter myOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);



myOleDbDataAdapter.Fill(myDataSet);

DataGrid1.DataSource = myDataSet.Tables[0];

DataGrid1.DataBind();

myConnection.Close();



}

catch(Exception exp)

{

Label2.Text = "<br>Error: " + exp.Message + "<br>";



}



}

View 3 Replies View Related

Sql Sever 2000 Develloper Version Limitations

Jan 13, 2005

I installed SQL Server 2000 Develloper version and I am wondering what are the limitation of this version compare to the other versions available? Like how many connections can I have open at the same time? Can I use it for my intranet application? etc...
Thanks

View 1 Replies View Related

Unix Connectivity Tools To Sql Sever 2000

Jul 20, 2005

Does anyone know of any shareware tools out there that can connect tosql server 2000 from Unix(specifically Sun Solaris) and performqueries and return result sets ? Appreciate your help.Steve Chiang

View 1 Replies View Related

Migrating From Access 2000 To SQl Server 2000

Jul 20, 2005

Hi,I have developed an application using VB 6 (SP 5), MS Access 2000 andCrystal Reports 9. I migrated from from access to SQl Server 2000.This wasn't a problem as i could import all the tables to SQL Server.Also, i could make VB6 talk to SQl Server.The problem arsies when i run my application. The sql syntax foraccess seems to be different than that for SQL Server. A simpleexample being: In access boolean datatype is true/false ,whereas inSQL Server the boolean equivalent is bit (numerical 1 or 0). Thesekind of issues are causing problems and most queries don't run.Would i need to go and change all the queries in accordance with SQlServer syntax ,which would be very time consuming or is there anyfunction which will convert the access datatype into its equivalentSQl Server datatype??Any input/thoughts/suggestions would be appreciated.ThanksJatin

View 1 Replies View Related

Can't Connect To SQL Sever 2005 After Upgrading From SQL Server 2000

Sep 6, 2006

I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:

ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07

hoainit (3): ; hoainit Exited with retcode = 0.

hoalgon (7): ; hoalgon Entered. name = edw.

DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login

failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL

Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220

nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220

hoalgon (7): ; hoalgon Exited with retcode = 28500.

View 6 Replies View Related

Data Migration From SQL 2000 To SQL Sever 2005 Express

Oct 24, 2007

We have a SQL Server 2000 and want to migrate to SQL Server 2005 Express.

It's possible?
SQL Server 2005 Express have support to do this?

View 6 Replies View Related

Installing SQL Server 2005 On Same Machine As An Existing SQL Sever 2000 Instance

Sep 8, 2005

Given than once SQL Server 2005 is installed, SQL Server Studio has to
be used instead of Enterprise manager, can both SQL 2000 and 2005 be
used on the same machine, be it development or production? (The second
one to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.

View 2 Replies View Related

Migrating 7.0 To 2000

Feb 12, 2006

i have computer with windows 2000 an sql 7.0 (computerA)
goal is windows 2003 with sql 2005

I see my choices as is:

A) upgrade win2k to 2k3 then upgrade sql7 on w2k3 to sql2k5 on win2k3.
(i see many potential problems with that)

B) have computerB with clean install of win2k3 and install sql2k5 on it.
if this is the case, what is the best / easiest way to get the database from 7 to 2k5? Database copy wizard? dts? attaching the db?

Anything else I should lookout for ?

thnx,
vext

View 4 Replies View Related

SQL 6.5 Migrating To SQL 2000

Jul 23, 2005

Hi,I've got a database that needs to migrate from SQL 6.5 to SQL 2000. I'mhaving problems with Datetime data types. In SQL 6.5 the Date is shown as'Mar 23 2004 12:00AM' but when I've copied the database across to SQL 2000,although it's still a Datetime data type, it is displayed as '2004-03-2300:00:00.000'. Unfortunately it means Stored Procedures called through afront end Visual Basic application do not work.Colleagues have suggested checking the collation, which I did and it's thesame as the older 6.5 database. Is there another property that needs to bechanged to allow the new Datetime dates to be shown in the desired format?FYI I have Systems Administrator privileges on the older 6.5 database butnot on the new 2000 one.I'm hoping there must be an flag/option I can change. Any help would begratefully appreciated.Kind regardsRich

View 1 Replies View Related

Advice For Migrating From SQL 7 To SQL 2000

Sep 11, 2003

We are about to migrate just over 30 databases from a SQL server 7 installation to a SQL 2000 on a different server. Each database has it's own logins.

What is the best, and most fool-proof path to take? I know from previous experience that restoring a single database works fine, but that the logins are orphaned. Are there complications with restoring the master database from the SQL 7 machine on the SQL 2000 machine? Any advice would be helpful as this is bound to be a painful process. ;-)

Thanks!

View 3 Replies View Related

Migrating DB's From SQL 2000 To 2005

May 15, 2007

Hi all,

I'm in need of migrating DB's from a SQL 2000 server to a new SQL 2005 server. Has anyone had any success in this or does anyone know of a process which would be best for this situation?

Here's my setup...

SQL2000 SERVER....OS - Server 2000
MDF's/LDF's reside on D:MSSQLData
Backups reside on D:MSSQLBackup

SQL2005 SERVER....OS - Server 2003
MDF's/LDF's reside on E:MSSQLData
Backups reside on E:MSSQLBackup

Any information on how to get these DB from 2000 to 2005 will be greatly appreciated.

View 9 Replies View Related

About Migrating To 2005 From 2000.

Jun 12, 2007

Hi, since havenot done migration yet, my company is planning to migrate from sql 2000 to sql 2005 server. and i am in group for capacity planning. can anybody suggest me the steps i should be really taking in order to migrate to 2005, if anyone has done the it in real world with database up to 50g.
thanks
Derek

View 1 Replies View Related

Migrating To 2005 From 2000

Mar 26, 2008

Guys! Very very junior in this migration part. Hope the seniors can help out....PLEASE!!!!!! Don't get me wrong asking you guys to spoon feed me. I have read a lot of articles and even BOL and also not to forget read millions of books on this. But just wanted to make sure that I am in the right path and want to do this without any problem. That's why I have decided to ask the Gurus here who have done this in past.

I have this machine now:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: )


Migrating to this machine:

Microsoft SQL Server 2005 - (X64)
Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

I have these in the SQL Server 2000 box:
1. Databases, tables (of course)
2. Views
3. Securities(Logins, Roles, Password)
4. DTS packages
5. Jobs
6. Replications
7. Linked Servers
8. Stored Procedures

Every article is different. I was confused at a point of time. Please show me the right way guys!

View 8 Replies View Related

Migrating From 32 Bit (2000) To 64 Bit (2005)

Mar 27, 2008

Yesterday I started this topic and I came step by step higher and now I have finalized my steps to migrate.

Seniors and Gurus and who has done this before, please review and correct me where I am wrong and/or add some tips for me to have this one going on successfully! Thanking all of you guys in advance! Here is what I have:

Before Migrating:
1. Install Service Packs, Security Patches and Hot Fixes
2. Install DTS Designer Tool from Microsoft to prevent conflict and failure of migrating current DTS packages to SQL Server 2005
3. Backup EACH and EVERY Database and double check the .bak files whether it exist and backup was successful
4. Just before migrating, reboot the server to clarify that the SQL Server Services and SQL Server Agent is working
When you are ready to migrate:
5. Make sure there are no users trying to connect to the OLD AND the NEW SQL Server. Inform them well in advance about the downtime. Shutdown any applications or websites that might be accessing the SQL Server.
6. Stop the SQL Server, SQL Agent and MS Search Services on the NEW SQL Server
If downtime is not possible:
7. For ever changing OLTP database, by the time you restore the backup onto the new server, the old server would have received more changes. To avoid this problem, you need to resort to log shipping. Log shipping is nothing but an automated process of backup and restore. The following steps will explain the process of log shipping (Note that SQL Server 2000 Enterprise Edition provides inbuilt logs hipping. We don't need that for this purpose. We can simply create a job that backs up and restores the databases
8. Create a job on the old server, with two steps. The first steps backs up the transaction log of the OLTP database. The second step restores this transaction log backup file onto the new server, using WITH STANDBY or WITH NORECOVERY option of the RESTORE command. Schedule this job to run every 10 minutes or 15 minutes, depending on the volume of transactions your OLTP database receives
9. This job will take care of shipping all new transactions since the full database backup, to the database on the new server. Let this job run until you can afford some downtime on your production database (that is, mid-night, or early morning, or a planned maintenance window)
10. Now to be doubly sure, no new transactions are coming in, set the database in 'single user' or 'dbo use only' mode. Take one last transaction log backup of the production OLTP database, and restore it onto the database on new server. This time use the WITH RECOVERY option of the RESTORE command
11. Run UPDATE_STATISTIC on User Database to reorganize all indexes
Considerations:
12. Security - The security model changed along with object ownership, but users that own objects will be turned into schemas and all of the object and role permissions will come over. These you will want to look over afterwards, but they should be ok.
13. Unless you have hundreds of them, it is always better to re-create them after upgrading. You cannot detach an MSDB database on a 2000 server and attach it on a 2005 server and have it work. Fortunate in this, we can script out the jobs from SQL Server 2000 and run it on the new SQL Server 2005
14. Typically you will have to re-create your replication too. Again, the good news is that you can generate the scripts for replication on a 2000 server and execute them on a 2005 server and it will create the appropriate articles and publications
15. For DTS packages, it is always recommended to use the Package Migration wizard to do this so that less or no problems will be encountered. Consider about the jobs previously set.
16. Logins can be created by using sp_hexadecimal and sp_revlogin2005

View 6 Replies View Related

Migrating SQL 2000 To SQL 2005

Jun 21, 2007

Hi Friends,Is there any tool or assistant to upgrade SQL 2000 to SQL 2005.Thanks,Arunkumar

View 2 Replies View Related

Migrating A SQL 2000 DB To A SQL 2005 DB

Mar 29, 2007

I would like to find out what the steps are to migrate a 2000 database up to 2005?



View 4 Replies View Related

Migrating From 2000 To 2005

Aug 14, 2007

Hello guys, I have vry basic question. I'm migrating from 2000 to 2005. MY question is do we have to recode all packages or just migrating of old 2000 DTS is fine. If so, then I can see only small icon of DTS package in 2005, whihc is not showing the details of DTS. Kindly, explain me what do i really do, migrating old one or re-creating new in 2005. Thanks in Advance

View 1 Replies View Related

Migrating Acceess To Sql Server 2000

Oct 3, 2002

Any suggestions on migrating Access97 tables to sql server 2000? The DTS seems cumbersome and the Access97 upsizing wizard add-in is only compatible up to sql server 7.0.

Thanks

View 1 Replies View Related

Migrating Sybase To SQL Server 2000

Feb 25, 2008

Hi all

I try to migrate sybase to SQL Server 2000, but found a los of trouble, please, some can help me to resolve this???

May many of that are easy to resolv, but is mi fist time with SQL Server 2000... plz, help :(

Object : Procedure
Error : Sintaxis incorrecta cerca de la palabra clave 'cursor'.
Code :

Create Procedure ABA_CenResul
as
Begin
declare @EST_CEN_Codigo char(8),
@EST_CEN_Descripcio char(100),
@n char(100),
@name char(100),
@salida char(8),
@vble int,
@ini int,
@ter int,
@indice int,
@aux_descripcion char(100)
declare sonido cursor
for
select EST_CEN_Codigo, EST_CEN_Descripcio
from EST_CenResul
open sonido
fetch sonido into @EST_CEN_Codigo,@EST_CEN_Descripcio
select @EST_CEN_Descripcio = @EST_CEN_Descripcio + " "
select @aux_descripcion = @EST_CEN_Descripcio
while @@sqlstatus !=2
begin
select @indice = 1
while @indice <> 4
begin
select @vble = patindex("% %",@EST_CEN_Descripcio)
select @ter = @vble - 1
select @name = substring(@EST_CEN_Descripcio,1,@ter)
if @indice = 1
select @n = @name
else
select @n = @n + "/" + @name

select @ini = @vble + 1
select @EST_CEN_Descripcio = substring(@EST_CEN_Descripcio,@ini,100)
select @indice = @indice + 1
end
print @n
exec sdxsrvr...soundex @n, @salida out
update EST_CenResul
set EST_CEN_Soundex = @salida
where EST_CEN_Codigo = @EST_CEN_Codigo
fetch sonido into @EST_CEN_Codigo, @EST_CEN_Descripcio
-- select @EST_CEN_Descripcio = @EST_CEN_Descripcio + " "
-- select @aux_descripcion = @EST_CEN_Descripcio
end
close sonido
deallocate cursor sonido
end



Thnx in advance

View 2 Replies View Related

Migrating From Oracle 8i To SQL Server 2000

Jan 31, 2004

Hi
I am trying to migrate my database in Oracle 8i to Sql Server 2000 but am unsure of how to carry out the migration. How do I do it and what do I have to consider. My OS is Windows 2003. Thanks in advance

View 2 Replies View Related

Migrating SQL Server 2000 Logins

Mar 27, 2004

I'm changing servers and want to copy all the logins from the old server to the new server. Is there anyway to do this?

View 5 Replies View Related

Migrating 2000 To 2005 On Same Server

Apr 2, 2008

Has anyone had experience of migrating from 2000 to 2005 on the same box , and maintaining the SERVERNAMEINSTANCE_NAME.
What are some effective ways of migrating and retaining the same servername/instance name ?

The issue revolves around minimising the use of extra boxes , as I would like to do the migration on the same server and keep the name the same .

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

View 3 Replies View Related

Migrating Access To SQL 2000 Server

Apr 25, 2007

Hi,

I need to migrate my access database to SQL2000 Server. I have three tables in my access database. In each table have 3000-6000 records.
So how to put all these records in to sql2000 server tables.
The table structure in Access database and sql2000 database are same.

Here core work is just insert all these 3000 - 6000 records (rows) from Access database to sql2000 database

Thanks in Advance!!

With regards
Shaji

View 5 Replies View Related







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