<div>
should i create every single table in sql and then import the data?<br />
should i review the config of each table?<br />
<br />
what is the best way, because even it is working it's taking to long to populate data in forms?<br />
so how can i prove my team that sql offer better performance than access, when it is acting slower
</div>


should i create every single table in sql and then import the data?
should i review the config of each table?

what is the best way, because even it is working it's taking to long to populate data in forms?
so how can i prove my team that sql offer better performance than access, when it is acting slower

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a split database(front end/back end), i just upsized it sql server.<br />
everything is working fine, but it seems to be slower, when it tries to open forms it takes a while to load the data, i thought it was going to be faster.<br />
do i have to do anything to improve the performance?<br />
do i have to recreate all the relationships in sql, are the relationships migrated directly?<br />
I am doing a test and runing everything from &nbsp;a windows 7 professional 32 bit workstation.<br />
<br />
please elt me know<br />
<br />
thanks<br />

</div>
</div>


Hi

I have a split database(front end/back end), i just upsized it sql server.
everything is working fine, but it seems to be slower, when it tries to open forms it takes a while to load the data, i thought it was going to be faster.
do i have to do anything to improve the performance?
do i have to recreate all the relationships in sql, are the relationships migrated directly?
I am doing a test and runing everything from  a windows 7 professional 32 bit workstation.

please elt me know

thanks


Access 2007 migration to sql server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.