Replication From A 2005 Database To A 2000 Database

Jun 7, 2006

Is it possible to setup replication for a particular database from an SQL2005 database server to a SQL2000 database server.

I've searched a few forums and the MS knowledge base but can't find a specific answer.

Hopefully someone can point this novice in the right direction.

Mike

View 1 Replies


ADVERTISEMENT

Transactional Replication From SQL 2005 To SQL 2000 Affects Performance Of Database.

Sep 21, 2007



Hello,

We previously having two servers A and B. Server A is used for updation of data and the data then replicated to server B. Server B is used for

Server A :
purpose : used for database updation/ modification
SQL Server version : SQL Server 2000 SP 2

Server Z :
purpose : used for Reporting
SQL Server version : SQL Server 2000 SP 2


We were doing Transactional replication from Server A to Server B.

Last month we have broght another server (Server B) with same hardware configuration but having SQL SERVER 2005 installed. This is to speed up our database update process. We have moved some of the database on this new server so that we can achieve our deadlines.

Server B :
purpose : used for database updation/ modification
SQL Server version : SQL Server 2005

I have set up the transactional replication from Server B to Server Z and replication works fine.
However, the issue is after it is started replicating from this new server (Server B) performance of all the queries reduced a lot.(making my life harder)

I didnt expected this as our reporting server is still SQL server 2000.
I have restored the backup of database which was replicated from server A (sql server 2000) and compared execution plan for one of our common query (which is used in most of the reports and which is now taking longer time to provide results)

I found that database which is replicated from Server B (Sql server 2005) is having primary keys. which was not present in the database which replicated from server A(Sql server 2000).

I have then removed the primary key and make the indexes same as previous copy of database(which was replicated from server A) But still the query takes long time.

Execution plan now shows "Table Spool" which was not present in previous copy of database.

Almost every query for this database is taking longer time now.

Can someone suggest me what is wrong and what should I need to fix.

Am I going on the right direction?


View 14 Replies View Related

Recreating A Sql Server 2000 Database As A 2005 Database

Jan 25, 2007

 
I am working on a project that was written in Visual Studio 2003 using asp.net and C#.  The project accesses a SQL Server 2000 database. I need to test the application. What I want to do is to copy the database over to a test server. The problem is that the test server only has SQL Server 2005 on it. Would it be a problem if I backed up the database using SQL Server 2000 and then recreated it on the server as a SQL server 2005 project? Would my source code accept the new database even though it would now be in sql server 2005? 
 

View 2 Replies View Related

Problem With Migration Sql 2000 Database To Sql 2005 Database

Mar 21, 2007

Hi all

I have a problem with the migration of databases from sql 2000 to sql 2005.

When i try to create the table or when i try to import the database, the below message is prompt:

Mens. 2782, Nivel 16, Estado 1, Línea 1

La instrucción DDL no está permitida.



Any ideas about this problem?

Thanks in advance

View 1 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

Updating Sql 2000 Database From Sql 2005 Database

Jul 27, 2006

i have sql 2005 installed on my personal machine, but our server has sql 2000 on it. the structure of my database was made on the server, but i'm not sure how to update the server copy from my local copy. when i try to export my data from my local machine to the server (or import from my local machine to the server), i get pre-execute errors.

roughly every other week, i'll need to be able to update the server version from my local version, so i'm trying to find the most efficient method. what is the best way to update a 2000 database from a 2005 database? it doesn't matter if i append or overwrite, but i do use identity fields. the error i get when trying to use the import/export wizard is:



- Pre-execute (Error)



Messages

Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
(SQL Server Import and Export Wizard)


Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)


Error 0xc004701a: Data Flow Task: component "Destination 3 - ReleaseNotes" (202) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard)

View 4 Replies View Related

Replication :: Syncing Of Database From Local Host Database To Online Database Automatically After Some Interval

Oct 14, 2015

I have database on localhost and i want to show this data on my website. I want to create a database online and want to sync with Local Host. Can it be possible syncing data automatically after some interval?

View 6 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

Conversion Of MSSql 2000 Database To MSSQL 2005 Database

Jan 18, 2008

How to convert a database in MSSQL 2000 to MSSQL 2005 database.Is there any tool or documentation available for this?

View 3 Replies View Related

How Do I Create A SQL 2005 Database From A SQL 2000

Aug 23, 2007

I have a SQL 2000 database on one server that I'm trying to transfer to a new server.  The new server has Small Business Server R2 Premium Edition, which includes SQL 2005.
I tried to transfer the database in the normal way that I'd create a copy database, which was: -1.   Backup the source database2.   Create a new database (empty) in the new server3.   Restore to this database from the backup taken in #1.
Of course on previous occasions I wasn't changing version, but I expected that this would either fail immediately (message "incorrect version" or some such), or else work.
At first this appeared to transfer OK.  It took about 20 minutes to create the backup (just over 5GB), and about the same time to restore it.  The restore terminated with a message "Database has been restored successfully").    However, the database's icon in Management Studio's Object explorer showed a little up arrow, and alongside the database name "(restoring ....)". Clicking on the database icon did not expand it.  3 hours later it still was like this.   Examining the server showed zero activity.
I expect that it's failed, and I should delete the new "(restoring...)" database and start again.  How should I create this SQL 2005 database?
 

View 3 Replies View Related

I Need To Converse My Database From 2005 To 2000.

Sep 28, 2007

hi evey body:
      I have a sql  2005 database. But now i need to turn this database to be sql 2000 database. How can i do that.

View 2 Replies View Related

Saving Database From 2005 To 2000

Dec 15, 2007

i work on sql server 2005 at home and have created a database with several tables and dabase diagram , now how do i transfer it to sql server 2000 which i work on at work ,
can somebody point me in the right direction in which this is done
any hlp appreciated

View 1 Replies View Related

2000 Database Restored To 2005

Jan 20, 2006

Is there a way to restore a 2000 database to 2005?
will the restore process convert automatically to 2005?

View 1 Replies View Related

How Can I Restore A SQL 2005 Database On My SQL 2000?

Aug 4, 2007

My customer has SQL Server 2005. I have SQL Server 2000 on my laptop (on XP Pro). I believe I have an empty database the same as theirs, but I need to restore their data. They sent me a normal SQL Backup, but my laptop threw a fit and cannot work with it.

They are now trying to export the database to Microsoft Access and send me that, but I won't get that until next week now. However is there a better and easier solution for those of us with insufficient experience of this, please?

Many thanks,
Caspar

View 3 Replies View Related

Best Way To Migrate Database From 2000 To 2005

Jun 5, 2008

Dear All,
at present all our servers are running with sql server 2000. we are planned to upgrade to sql server 2005 standard edition. what is the approach i need to follow?
can i directly go for installation of sql server 2005, and then use copy database wizard? this is a production environment, and we even not give 5 min of downtime. please help me in this regard

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 5 Replies View Related

How To Import Sql 2000 Database Into Sql 2005

Mar 12, 2007

Hi,
I have developed an application in .NET 2005 using sql server 2005.
This is the enhancement to the existing application.Now whats the problem is, one of the customer wants his old database, which is in sql 2000 server with the new database(sql 2005 server). So, how can i import sqlserver 2000 database into sqlserver 2005 database.

Its very urgent plz.........
Regards,
Kishore

View 1 Replies View Related

Migrating SQL 2000 Database To SQL 2005

May 23, 2007

Hi,
I have a database on a SQL Server 2000, and would like to migrate it to a new server machine that has SQL Server 2005. has anyone already tried this, and can you please provide the steps to follow.

Thank you.

View 7 Replies View Related

Downgrade Database Of 2000 To 2005?

Jul 31, 2007

anyone knows how to do that?

M i K e

View 1 Replies View Related

Copying Database From SQL 2000 To SQL 2005

Nov 7, 2007

Hi,

I need to copy database from SQL 2000 to SQL 2005 server. I was using the Copy wizard from SQL 2000 Server, I could enter the source server and server where to copy SQL 2005 but when I wanted to select the database to copy, nothing happened. Like I was kicked out, no errors etc.

Any one with idea or information, please let me know ASAP

View 9 Replies View Related

Downgrade Database From SQL 2005 To SQL 2000

Jan 24, 2008

Is that possible to move a database from SQL 2005 to SQL 2000? How?

Thanks a lot.

View 2 Replies View Related

Is It Possible To Move A Database From 2005 To 2000?

Sep 7, 2006

Hello,I have a database in 2005 that I'd like to copy and attach in 2000. Is thispossible? if so, how do I do it? I've tried doing a number of things fromjust trying to attach to the db file to trying to export and import viaaccess and I can't seem to get anything to work.Any help would be greatly appreciated.Thanks!Rick

View 1 Replies View Related

Can Sql 2005 Database Be Used By Sql 2000 Server

Sep 12, 2007

Hi i am a newbie and an developer i have an issue the Development we are doing is on sql server 2005 and we are wanting to send this database for a front end team to develop fromt end and they are using sql server 2000 , will there be any problems with regarding to version. if there are problems what would be the way to provide them with the Data.

View 3 Replies View Related

Database Upgrade From Sql 2000 To 2005

Oct 10, 2007



i am upgrading sql server 2000 database to sql server 2005 database.
I am using backup and restore method to upgrade.

i have an issues transferring the logins..

what is the best why to upgrade?????any info is appreciated..

View 10 Replies View Related

Is It Possible To Migrate Database From 2005 To 2000

Apr 21, 2008

hi
can any one help me to find a way to migrate a database from 2005 to 2000

thanks

View 1 Replies View Related

Restore A SQL 2005 Database On SQL 2000

Aug 13, 2006

Hello,

If I have a SQL 2005 database set to SQL 2000 Compatiblity can I create a backup on SQL 2005 that can be restore on SQL 2000.

Michael

View 1 Replies View Related

SQL 2000 Database Upgrade To 2005

Dec 12, 2006



Dear All..

I have a few databases running a sql2000 and the time as come to move them onto sql2005. Which would be the best route to take.

If I can think back to older version it was just a simply job of doing a backup in it's current version then restore in the new version? and upgrade was taken while restoring.. I could be wrong but any help !!

Thanks

Martin.

View 5 Replies View Related

Convert Database From Sql 2005 To Sql 2000

Nov 15, 2006

Hi,

Can anybody tell me that how to convert database from sql server 2005 to sql server 2000. I tried with generated script and in that i selected the option for sql server 2000 but still while trying to run that script it is throwing an error. the error is:



Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.




plz help.



Thanks,

Poonam

View 1 Replies View Related

RS 2005 Run On SQL Server 2000 Database?

Oct 4, 2005

Our product currently works with Cystal Reports but we decided to enhance it so it works with another reporting platform (MS Reporting Services).   We are in the beginning stages of developement and trying to decide which version of RS (2000 or 2005?) to build the reports and integrate our web UI with.  Most of our clients are using SQL Server 2000 for their database platform and we don't anticpate them upgrading to 2005 in the near future.   

View 19 Replies View Related

How To Transport A Database In SQL 2000 To 2005

Oct 21, 2007

How do I take a database developed and operating and get into the 2005 SQL Server?

View 4 Replies View Related

2 Questions (SQL 2000 To 2005 Database Conversion)

Aug 8, 2006

I have a db in SQL server 2000 developer edition. I am using Visual Studio 2005 standard, and also VWD Express. I would like to just access the database that is in SQL server 2000 so I can get on with developing the site, but VS2005 refuses to recognize the instance. It recognizes 2005 instances right away.The services are all running, the network protocols are enabled, uid's/pw all of that is correct. I am getting the "named pipes" error (the named pipes protocol is enabled).Any suggestions? I'd really rather just work with the db as-is in SQL 2000. But I can't get it to connect. I can connect to it if I export it to SQL 2005, (on the same development machine) but can't get the stored procs over to the 2005 db. So my web app is not finding the stored procs and won't run.Do I need to uninstall SQL 2005 from this box if I want to use SQL 2000?Thanks,--Donnie

View 13 Replies View Related

Restored Database From Sql Server 2005 To 2000

May 16, 2007

Is there any workaround on this? I need to migrate my data in sql server 2005 into sql server 2000. Thanks in advance.

View 2 Replies View Related

Backup Sqlexpress 2005 To A 2000 Database -

Jan 14, 2008

I have sqlexpress 2005 on my local machine - but my hoster has sql 2000 - so i used the DB publishing wizard to create the script and sent it over to them - they are now saying that they need a .bak file in 2000 to host my database - is this a bunch of horse hockey or not?
if this is legit - any ideas on how I can create a .bak 2000 sql from sqlexpress 2005?
 
many thanks

View 5 Replies View Related

Restoring A 2005 DataBase Into A 2000 Server

Mar 12, 2007

I would like to know if it is possible to make a backup of a database in a SQL Server 2005 server and restoring it in a SQL Server 2000 server.

Thanks a lot in advanced.

View 5 Replies View Related







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