Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question | March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000 Thanks in Advance
Answer Question | March 27, 2011 7:41 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration
HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.
Answer Question | March 2, 2011 11:34 AM
SQL database conversion, SQL Server 2000, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?
Answer Question | February 11, 2011 9:12 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?
Answer Question | January 3, 2011 4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
how to attach database of sql 2008 into sql 2005
Answer Question | December 1, 2010 6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration
project plan with steps outlined
Answer Question | January 12, 2011 5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.
Answer Question | January 6, 2011 3:21 PM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?
Answer Question | September 21, 2010 3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.
Answer Question | September 8, 2010 8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008
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.
Answer Question | July 23, 2010 8:01 PM
SQL Server, SQL Server 2005, SQL Server 2005 upgrade, SQL Server migration, SQL Server Upgrade
We have an AS/400 that no one in our agency knows anything about except that it has been running for a few years and the data needs to be removed from the AS/400 to another platform, either DB2 or SQL Server. I have read that a SQL ssis package can be used to migrate the [...]
Answer Question | October 20, 2010 4:41 PM
AS/400 DB2, AS/400 migration, AS/400 SSIS, SQL Server migration
Hello, Please let me know is there any tool available to check the SQL Server 2000 to Sql Server 2008 Migration, so that we can anlyze the procedure or any discrepancies with the Database we are trying to migrate and list all potential issues. Thanks Naina
Answer Question | January 6, 2011 6:29 AM
Microsoft SQL Server 2000, SQL Server, SQL Server 2000 administration, SQL Server migration, SQL Server Migration Assistant
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 [...]
Answer Question | April 13, 2010 5:39 PM
DB2, SQL Server migration
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.
Answer Question | June 25, 2009 4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005
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?
Answer Question | May 15, 2009 1:02 AM
SQL Server (32-bit), SQL Server (64-bit), SQL Server migration
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.
Answer Question | April 28, 2009 9:29 AM
Index Scan, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server upgrades, SQL Server views
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?
Answer Question | April 7, 2009 5:48 AM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, SSIS
Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?
Answer Question | August 10, 2010 6:22 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration
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. [...]
Answer Question | February 10, 2009 2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008