Attach MDF tool

I'm pretty sure maintaining that data will be completely up to you. It should be a pretty straight-forward task, however.

Just make sure the new database is up and running, then momentarily turn off public access to your site (so updates aren't made while you're trying to transfer the data) then import the data into SQL, point your site to use the new database and turn everything back on. It may be something worth practicing locally if your site gets enough traffic where the downtime would be a problem.

 

I am looking to upgrade our access database to SQL server and I am developing it locally on SQL Server Express. We currently have about 4000 records on our access database. My plan is to upsize the access database in SQL Server express, develop a new front end site in ASP.NET2.0 and then upload the database and new web pages to SQL server using the attach MDF tool.

I am slightly worried about the transfer of the actual data itself, will these be kept when transferring to the DiscounASP SQL server or not???

Thanks

James

 

The Attach tool will actually move your mdf file to the SQL server and then attached. You can delete the MDF file that you uploaded afterward.

Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

Are you sure????

Unless this is a really cool new feature of SQL 2005 I don't think you can simply attach an Access MDF file to SQL as a SQL Server DB. The structure of the file is vastly different. Correct me if I'm wrong, but I think someone is telling porkies!!!

 

The original poster was talking about a SQL Express database, not Access.

Aristotle

DiscountASP.NET
www.DiscountASP.NET