Results 1 to 2 of 2

Thread: Migrating

  1. #1
    Join Date
    Mar 2004
    Posts
    27

    Red face Unanswered: Migrating

    Hello People,

    I currently have a MS Access database that will eventually be migrated to MS SQL Server. There won't be an application now, just the database and the reports. My doubts are on how easy this transition will be.
    1 - After I build all the database with tables and relationships, is there a tool that helps me to import data?
    2 - Is there a way to insert the data on the database other than writing the SQL codes, I mean maybe creating some 'forms'?
    3 - Once the data is in, it there a way for me to create report on the SQL Server itself or do I need a report generator like Cristal Reports for example;
    4 - If yes, then how easy it is to integrate them;
    5 - Is it complicated to generate these reports or it is pretty much the same interface as in Access or Delphi?

    Thanks a lot

    Atha
    Atha
    20175337

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Quote Originally Posted by atha
    1 - After I build all the database with tables and relationships, is there a tool that helps me to import data?
    The DTS Wizard that comes with sqlserver can help you out a lot here.

    Quote Originally Posted by atha
    2 - Is there a way to insert the data on the database other than writing the SQL codes, I mean maybe creating some 'forms'?
    The DTS Wizard is a full wizard and easy to use, it will confront you with the tables from access though.
    Quote Originally Posted by atha
    3 - Once the data is in, it there a way for me to create report on the SQL Server itself or do I need a report generator like Cristal Reports for example;
    SQLServer does not have reports ready to run or supports forms suchs as Access. Crystal Reports or any other reporting tool can help you out.
    4 - If yes, then how easy it is to integrate them;
    Quote Originally Posted by atha
    5 - Is it complicated to generate these reports or it is pretty much the same interface as in Access or Delphi?
    SQLServer can be accessed using ADO making it easy for tools as Crystal Reports, the same goes for Access. I'm not sure what you mean by Delphi, but Delphi supports ADO very well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •