Synchronising Data Between SQL 2000 32 Bit And SQL 2005 64 Bit Servers

Nov 17, 2006

Hi

I have a production system running sql 2000 server 32 bit

Now i am planning to move to SQL server 2005 64 bit setup .

I need to have a set up of both SQL 2000 and sql 2005 in parallel for some time until it is sure that the sytem can completly move .

The problem is how do i synchronize the data in the two servers when they are operating parallely.....

Please advice.

Thanks in advance......

View 1 Replies

Linking SQL 2005 Servers To SQL 2000 Servers Problems

Sep 27, 2007

I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.

1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.

Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)

If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.

Thanks!

Brandon Forest

Database Administrator

Data & Web Services Team

Sutter Connect Information Technologyforesb@sutterhealth.org

View 2 Replies View Related

Synchronising SQL CE Database With SQL 2000 Using Active Sync In 2003

Feb 8, 2007

HI ,

I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem

Thanks in Advance

Regards

Ihsan

View 8 Replies View Related

Synchronising Data Between 2 SQL Server 7 Databases - Help ;o)

Oct 4, 2001

Hi, can anyone point me in the right direction of how to sync an in-house SQL Server 7 with a remote SQL server 7.

We are a development house. We build website using SQL server 7 databases then move them up to an entirely different SQL server 7 database in a remote location.

Now, please don't laugh, currently we export all the data from the development server into a csv and import it back into the live server. As you can imagine, it's clunky, time consuming and unreliable.

Is there a way to automatically sync the two? I tried desperately to find any information but even the MicroSoft MCSE training manual on SQL doesn't say how to do this.

Any help would be greatly appreciated.

Thanks in advance.

Chris

View 1 Replies View Related

Mulitiple Servers 2000 And 2005

Mar 30, 2007

Just wondering before I do it, I am in the UK and studying for an mcdba which i require sql server 2000 on my laptop but I'm also doing the sql server 2005 exams aswell at the same time,

Now I know that you can have multiple instances on sql server on one machine but would I be able to have 2000 and 2005 running on the same machine or would it not be advisable

Thanks

--------------------------
You only learn by practicing

View 2 Replies View Related

Linked Servers 2000/2005

Jul 26, 2005

I can't define a linked server in SQL Server 2005 x64 edition (to a SQLServer 2000 instance).

View 29 Replies View Related

4 Servers To Upgrade To SQL 2005 From SQL 2000

Dec 30, 2007

These are the steps i plan on taking.
1. sp_help_revlogin gets logins sql 2000
2. Backup from SQL 2000 to SQL 205
3. Change database to 90 mode
4. Change database to check sum and auto stats sync
5. Rebuild Indexes on databases
6. Jobs (i will manually move over)
Anything else i should run after the rebuilds

Thanks

View 2 Replies View Related

Problems With Linked Servers Between Sql 2000 And Sql 2005

Jun 2, 2007

Dear all

I have created linked server object between a sql 2000 and sql 2005 database. i have the latest mdacs installed and all the services enabled on both sides.
But when i try and run a sql statement on the sql 2000 side i get this error:
[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.
If i try and run a swl statment on the sql server 2005 side the procedure works.
Has anyone experienced the same problem?Any advice?

Thank you so much for the help.

Dan

View 2 Replies View Related

Sql 2005 To Sql 2000 Linked Servers Problem.

Jul 25, 2006

We have two sql servers using Windows authentication. One is sql 2000 the other sql 2005. When logged in as "sa", I can link these servers and run a SELECT distributed query without any problem.

But when one of our developers runs the same query (he is "dbo" of each database on each of the servers) he gets the error:

"OLE DB Provider "SQLNCLI" for linked server <Servername> returned message "Communication Link Failure"
...
Login failed for user '(null'). reason: Not associated with a trusted SQL Server connection"

Despite that, I, as "sa" equivalent, have no problem so it appears to be a permisisons issue. Any ideas what is going on here?

TIA,

Barkingdog

View 3 Replies View Related

Problems With Linked Servers Between Sql 2000 And Sql 2005

Jun 3, 2007

Dear all

I have created linked server object between a sql 2000 and sql 2005 database. i have the latest mdacs installed and all the services enabled on both sides.

But when i try and run a sql statement on the sql 2000 side i get this error:

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.

If i try and run a sql statment on the sql server 2005 side the procedure works.

Has anyone experienced the same problem?Any advice?

Thank you so much for the help.

Dan

View 4 Replies View Related

Linking SQL Server 2000 Servers In Express 2005

Jun 5, 2006

Hello,

I was wondering whether it is possible to query linked servers in SQL Server Management Studio Express 2005 if those servers linked to are SQL Server 2000 machines?

I have added some linked servers to express and queried them, however the login timeout is expiring. I thought it might be because of an incompatability.

Cheers,
Damien.

View 1 Replies View Related

SQL 2000 Enterprise Linking Of Servers Not Pulling Data.

Dec 8, 2006

I know this is an easy one for most of you but this is new territory for me.
I am trying to link a production application database to an existing SMS database.
Both of these databases are SQL 2000. I have sa access to both of them.
I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases.

For simplicity I will define them both.
Application Database we will call ��A-Database�?
SMS Database we will call ��B-Database�?

I have gone into the A-Database and gone to linked Servers under the security node in enterprise manager. I created a new linked database and selected the SQL Server option in the general Tab.
In the Security Tab I selected the ��Be made using the security context�? and used ��sa�? for the Remote login and the CORRECT sa password for the With password option.
The server options tab remain the same with �?RPC, RPC Out, & Use Remote Collation�? selected.

It appears to connect but there is not any Table or Views showing up. What am I doing wrong here and what do I need to do to link these 2 database engines so I can move forward?

Thanks,
Gene Godsey

View 7 Replies View Related

Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)

May 19, 2008

Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael

View 2 Replies View Related

Synchronising Via HTTPS

Dec 1, 2005

Hi,

View 4 Replies View Related

Synchronising Logins(Urgent)

Nov 19, 2001

Hello,

I've installed development server and created the databases, and restore the ddatabase from backups of production server, There the users in the databases which are not in sysxlogins in master, Please guide me how I can synchronise the logins? Can I bcp out sysxlogins from development and then bcp in in development server? Is there any way there even groups in the database and do I have to corncern about any other tables in master db

Thanks in Advance

Alpa

View 3 Replies View Related

Synchronising Databases With Different Schemas

Apr 28, 2008

Hey folks,

I'm looking to gather ideas on this before I start the project; so what better way to start than to ask here? ;)

The situation is this: we are in the process of replacing a large data driven application with a new one. Before turning the old'un off (that's not for a minimum of 6 months), we need to migrate data between the two entirely different schemas, and I've been tasked with writing the interfaces.

Now, here comes the kicker; they don't just want a "straight-forward data conversion", they want to run a period where they can still update both databases and any changes in the old one are to be pushed into the new db.

Because the schemas are not the same, I believe replication is out of the question so I was looking for advice as to what possibilies I have ahead of me to achieve this.

I fear I may not have expained this well enough; so as always if there are holes in the detail let me know and I'll do my best to fill them in :)

Old db = SQL Server 2000
New db = 2005

Thanks,
George

View 13 Replies View Related

Synchronising With Remote Server

Dec 25, 2005

HiWe have an internal ms access database which we need to synchronise with ourwebsite with sql server 2005 backend which is hosted on a public host. Myquestion is; is there a way to keep the two databases synchronised using thetechnologies built in sql server 2005 and/or access? We also have thepossibility of an in-house sql server 2000. Can this be used in anyway tohelp, perhaps by moving data from in house access to in house sql server2000 and then synching sql server 2000 and remote sql server 2005?ThanksRegards

View 1 Replies View Related

SQL CE Merge Synchronising Schedule

Jun 27, 2007

Hello guys,

I'm stumped. Is there a way to get a compact edition client (running on a standard PC) to automatically sync. (using merge replication) with a server on a schedule?

I can quite happily pull up SQL Managerment Studio and sync. on the client, but I want to have something running in the background basically doing this for me (again, on the client). I know I can do it in code, but we've not yet received our Visual Studio package, so for the moment, I want something already written to do it for me.

Surely this must be possible?

Thanks in advance!

View 8 Replies View Related

SYNCHRONISING XDA MINI S WITH PC USING VISTA

Jan 23, 2008

I have a problem synching my xda mini s with my pc using vista. A previous thread was unhelpfully closed by Ilya as being off topic; well it isn't on topic anywhere else. At least not according to microsoft's own search engine. Ilya, why not try giving a helpful answer instead of 'not my problem'? My xda will not synch using vista; XP and ActivSync has been perfect. I've tried installing mobile device centre version 6.1 but I suspect vista isn't compatible with Windows mobile version 5.1. Should it be? If not, is there a patch or is upgrading to vista going to cost another couple of hundred pounds to get a compatible mobile device? If so, I'm off to a different operating system. Perhaps, like many others, back to XP and let Microsoft continue to dither around and experiment on others.

View 1 Replies View Related

Synchronising/replicating Access With Sql Server

Dec 28, 2005

HiIs there a way to synchronise/replicate an access db with sql server 2000db, short of writing the code oneself?ThanksRegards

View 1 Replies View Related

Import Data From 2005 To 2000 DB

Dec 20, 2006

I have SSMSexpress which does not include the Tasks/Import Data...Is there an easy way to do this without the full SSMS?I have SQL Server 2005 express for developement which I like alot. Can I possibly load SSMS without installing the entire SQL Server 2005 product?
PS I am almost a complete idiot with SQL Server DBs and I use Visual Basic, not C#
thanksMilton

View 1 Replies View Related

Migrate Data From SQL 2000 To SQL 2005

Mar 10, 2008

Hi Everybody,
does anyone know how I can migrate SQL 2000 data to SQL 2005 database? I'm trying to create an application that will connect to SQL 2000 database using VS2003 and transfer data to SQL2005 database but it doesn't seem to work. Any suggestion is greatly appriciated.
devmetz.

View 1 Replies View Related

Data Transfer From SQL 2000 To SQL 2005

Apr 2, 2008

I am new to

View 4 Replies View Related

Sql 2000 To 2005 Data Transfer

Apr 27, 2007

I am trying to copy a database from sql2000 to sql2005 but it is giving me the following error:
To connect to this server you must use SQL Server Management studio or SQL server management objects (SMO)

this can be done or servers are not compatible?

View 2 Replies View Related

Data Migration From Sql 2000 To Sql 2005

Aug 28, 2007

hi. i am currently migrating data from sql server 2000 to sql server 2005 and i was wondering if any of you can help me. i found this tutorial

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

and it seems really straight forward. does this tutorial cover everything i need to do for data migration? do i need to watch out for anything? if anyone knows of a better tutorial please let me know. thanks for the help.

View 6 Replies View Related

Help With Data Migration 2000 To 2005

Mar 7, 2008

Hi all. I'll say from the get go that I'm no SQL guru. I'm primarily a web dev who has been given the data jobs kind of by default so I'm definitely no DBA.

Anyway, having established my noobness, I have encountered an issue. The employer recently decided to upgrade our databases from 2000 to 2005 and I have been tasked to migrate the data from old to new. I have discovered the Import/Export Wizard and got it to move all the data in a dev database we use...but there was one problem. It seems that the tables in 2000 that had columns designated as identity columns do not have the identity attribute when they arrive in 2005.

I haven't figured a way to alter them to give them that attribute once they're in 2005 so I'm wondering if there's something I can do/change in the import process that would retain the identity property of the columns if I were to re-import them.

This is my first migration attempt so dumping it and starting over is no great loss...but any help would be most appreciated.

View 6 Replies View Related

Is There A Way To Loghshipping Data From Sql 2000 To Sql 2005? Thanks

Jun 28, 2005

Is there a way to loghshipping data from sql 2000 to sql 2005? thanks

View 4 Replies View Related

How To Transfer Data From Sqlserver 2000 To 2005

Jan 4, 2008

Hi,
I am trying to transfer data from a sql server 2000 database to a Sql Server 2005 database... and i just want to transfer around 2 tables.. and my sql server 2000 database is located in one machine and the 2005 database is located in the other machine.. So i am trying to insert data into the sql server 2005 database. So can i do it like this..
Insert into SqlServer2005comp.Databasename..TableName
(
   Columns
)
Select
   Columns
From
     sqlserver2000comp.Databasename..tablenames
Where UserId = @UserId.
Is this the right way to do it.. and can i give this query in the sqlserver2005 db or the 2000 db
any help or ideas will be appreciated.
Regards...
Karen

View 9 Replies View Related

SQLEXPRESS 2005 To SQL 2000 Data Transfer?

May 28, 2008

Hi All! i have a database in SQLEXPRESS 2005 but i need to this Database in SQL 2000...there is any way to move data from sqlexpress 2005 to sql 2000.... please help me.....

View 4 Replies View Related

Copy Data And Objects From 2005 To 2000

May 17, 2008

Anyone who has successfully done this. Do reply. Thanks

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

Converting SQL 2000 Data Into A SQL 2005 Server

May 4, 2006

I have a large (huge) database that I want to copy onto my new slq 2005 test server. I'm leaning toward detaching the data on my 2000 box, duplicating it, copying it to my new 2005 machine, and attaching it. Is it possible that it could be that simple? If not, how is it done? Thanks a bunch for any help or pointers to the articles I was totally unable to find on the subject.

View 3 Replies View Related

Data From Sql Server 2000 And Reports On 2005

Jan 28, 2008

Hi,

I need to develop a Report using SSRS 2005, wher SQL Server 2000 as Database. Can we do that ?
If yes how to Create Data Source for it ?

our Network has both SQL 2000 and SQL 2005 Database Servers.

View 4 Replies View Related