• Migrate MySQL database to SQL 2005

    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?

    Karl Gechlik9,860 pointsBadges:
  • 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.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Send data from SQL Server to MS Access

    I'm a beginner to VB.NET andI want to transfer my data in SQL Server to MS Access. Please anyone can help me to this regard?

    Usjpcha10 pointsBadges:
  • Encryption Form SQL Server 2000

    I want to transfer data from one database to another database both the databases are on SQL Server 2000. I want to transfer the data in encryption form. How do I do it? Regards, Sahil

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

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

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • Reg:Problem with SSAS

    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 need to first migrate the...

    48102145 pointsBadges:
  • Create linked server from sql 2000 to sql 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

    ManosZim30 pointsBadges:
  • SQL Server 2005 Reporting Services Move

    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?

    Rick Martinez585 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Migration checker tool for Sql Server 2000 to Sql Server 2008 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

    Naina5 pointsBadges:
  • Migrating SQL Server 2000 to SQL Server 2005

    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.

    TeachMeIT975 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 to 2005

    after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?

    Parveshkaur5 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 pointsBadges:
  • Migrating from AS/400 to SQL Server

    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 data - I need to know what...

    Dharder15 pointsBadges:
  • Can I restore a SQL 2000 backup to a new SQL Server 2005?

    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.

    TeachMeIT975 pointsBadges:
  • Error when translating execute immediate from Oracle to SQL

    SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement,...

    Ariel5 pointsBadges:
  • How to migrate a database from SQL Server 2000 to SQL Server 2005

    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?

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