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?