SQL Server Migration

Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

Transferring SQL 7 DB to SQL 2005 DB

Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert

Is it possible to copy system DBs to another server?

Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

MIgration to 64-bit Sql Server

What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

Manually migrating databases from SQL Server 2000 to SQL Server 2005

I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

How to move a DTS from sql 7 to a server running sql 2005?

I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

SQL Database Migration Process

Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

What are the benefits of SQL Server 2005 over SQL Server 2000?

If i am satisfied with SQL 2000 then why I should go for SQL 2005

problem with sys.endpoints

Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

send data from sqlserver to ms access

i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .

SQL Server 2000 to SQL Server 2005 migration

Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason for that and how can we prevent...

Migrating from SQL Server 2000 to SQL Server 2005 on a failover cluster environment

I am planning to migrate my SQL Server 2000 databases to SQL Server 2005 on a failover cluster environment. What is the simplest strategy you could recommend to fulfill this goal?

Database migration from SQL Server 2000 to SQL Server 2005

I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? ...

Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database

I recently migrated some reports and stored procedures from a SQL Server 2005 database server in SQL Server 2000 compatibility mode to a SQL Server 2005 database. Afterwards, we have not been able to get the stored procedures to run to completion. We have found two issues: one is collation...

Storing attachments in tables on SQL Server 2005

I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?

Encryption Form SQL Server 2000

I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ..... Regards, Sahil

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

Migrating from MS Access to SQL Server Express

I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

Data Migration Betrieve Tables to MS SQL Server 2005

Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?