• Help upgrading from SQL Server 1997 to SQL Server 2005

    When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

    ITKE351,965 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 pointsBadges:
  • DB2 to SQL Server migration

    We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or for an AS/400 Systems Analyst? Also, the...

    SolpartDean5 pointsBadges:
  • Migrate User & Permissions SQL 2000 to SQL XXXX

    Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

    Njimenez5 pointsBadges:
  • Going from SQL Server 64-bit Enterprise to 32-bit Standard

    Can the database be moved from a 64-bit Enterprise Edition SQL server to the 32-bit Standard Edition? What kind of issues there might be associated with this move?

    Narine5 pointsBadges:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • Tool for migrating DTS to SSIS

    What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

    Lingala5 pointsBadges:
  • Copying view from remote to local SQL Server with SSMS

    Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using Export...

    Tsp196520 pointsBadges:
  • 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...

    Dschwant175 pointsBadges:
  • 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 gain....

    Nitin19835 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Amit1may5 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Snivas20 pointsBadges:
  • 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...

    Gauravpadia5 pointsBadges:
  • 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

    Bertski40 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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

    Deepatss5 pointsBadges:
  • 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.

    Vani175 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following