SQL Server 2008 compression experiences?
We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads – also proven in testing). [...]

Answer Question   |  February 2, 2009  8:50 PM
SQL Server 2005 to SQL Server 2008 Migration, SQL Server 2008, SQL Server 2008 Compression, SQL Server Compression, SQL Server migration

Migration from SQL Server 2000 to SQL Server 2005
Hi EveryBody, I am new to SQL SERVER 2005, I have migrated my SQL SERVER 2000 database to SQL SERVER 2005 and it has degraded my site performance. A Page that opens in 10 seconds is now opening in 30 seconds. I have updated the STATISTICS of the database using UPDATE STATISTICS command but no [...]

Answer Question   |  January 29, 2009  4:56 AM
SQL Server 2000 migration, SQL Server 2005 migration, SQL Server 2005 performance, SQL Server migration

Migrating data from a SQL Server 2005 database to SQL Server 2000
I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical [...]

Answer Question   |  January 27, 2009  7:52 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Migration, SQL Server migration

Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008
I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest me ASAP. [...]

Answer Question   |  January 7, 2009  9:23 AM
SQL Server 2000, SQL Server 2000 encryption, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 encryption, SQL Server migration

Restoring a database after migrating from SQL Server 7 to SQL Server 2005
I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error: “Processed 120424 pages for database ‘COAST’, file ‘Coast_Data’ on file 1. Processed 1 pages for database ‘COAST’, file ‘Coast_Log’ on file 1. Converting database ‘coast’ from version 515 to the [...]

Answer Question   |  December 31, 2008  8:06 PM
SQL Server 2005, SQL Server 7.x, SQL Server migration

Migrating SQL Server 2005 back to SQL Server 2000
How would I go about migrating SQL Server 2005 back to SQL Server 2000?

Answer Question   |  December 31, 2008  7:42 PM
SQL Server 2000, SQL Server 2005, SQL Server migration

Moving data from one DB to another DB in SQL Server 2005
Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length columns Max_Var_Size = maximum byte size of all variable-length columns Null_Bitmap = [...]

Answer Question   |  December 22, 2008  2:22 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration

SQL Server 2000 Enterprise Edition upgraded to SQL 2005
I am researching different Hosting companies with dedicated servers that we can look at moving to. I need to know some information when I am looking at these different companies about the SQL server. We are currently running SQL Server Enterprise 2000. I have seen that the companies are offering MSSQL 2005 in Express, Workgroup, [...]

Answer Question   |  December 20, 2008  7:21 AM
Dedicated servers, SQL Server, SQL Server 2000 Enterprise Edition, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, Web hosts

Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?
What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

Answer Question   |  December 12, 2008  8:15 AM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 performance, SQL Server migration, SQL Server performance, SQL Server upgrades

Changes in stored procedures from SQL Server 2000 to SQL Server 2005
If you could, could you please give a list of the relevant changes that have been done to stored procedures from SQL Server 2000 to SQL Server 2005?

Answer Question   |  December 10, 2008  7:52 PM
SQL Server 2005, SQL Server migration, SQL Server stored procedures

SQL 2005 32 bit – SQL 2005 64 bit
Moving from SQL 2005 32 bit – SQL 2005 64 bit. What are the problems which can be faced during this move.

Answer Question   |  December 2, 2008  9:16 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server migration

How to import Microsoft Access to SQL Server 2005
hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

Answer Question   |  December 2, 2008  4:41 PM
ASP.NET, C#, Microsoft Access, Microsoft Access import/export, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 migration, SQL Server migration, Web development

Migrate FROM SQL2005 Ent. TO SQL2005 Standard
We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do this. [...]

Answer Question   |  November 14, 2008  3:28 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server migration

Migrating SQL Server replication from one server to another
We are migrating our SQL Server from one server to another; is there a way that replication can also be moved from source to destination?

Answer Question   |  November 11, 2008  7:10 PM
SQL Server migration, SQL Server replication

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.

Answer Question   |  December 9, 2008  7:57 PM
DTS packages, Dynamics GP, Microsoft Dynamics GP, SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration

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

Answer Question   |  December 11, 2008  9:33 AM
Dell PowerEdge, SQL Server 2005, SQL Server 7.x, SQL Server import/export, SQL Server migration

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 [...]

Answer Question   |  October 9, 2008  3:38 AM
SQL Server 2005, SQL Server import/export, SQL Server migration, SQL Server replication

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?

Answer Question   |  October 9, 2008  12:38 PM
64-bit, SQL, SQL database replication, SQL Server 2000, SQL Server migration

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?

Answer Question   |  September 16, 2008  6:24 PM
SQL Server 2000, SQL Server 2005, SQL Server migration

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

Answer Question   |  September 15, 2008  4:15 PM
DTS, SQL Server 2005, SQL Server 7.x, SQL Server migration