Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to migrate from Access DB to MS SQL in a remote Server??

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-20 : 10:58:59
Edika writes "First of all, sorry for my English. Some month's ago i've open a free site just for pleasure but now is become a real activity, and my Access Db have now some table of more then 500.000 records, so is very slow in execute the query's. My Host give me the chance to use SQL server. I've just used SQL server at 'Real Work' but i administer it directly from the server with the enterprise manager, and i've just imported an Access Database using the migration wizard tool. Now i don't have access to the enterprise manager and how i have to import all the database from Access to SQL. There is some kind of Front-end to remote create table or i've to create al with sql script? Exist an utility that make the proper SQL script to replicate an access DB in SQL server?.
I know my answer can be very stupid but i think can be very helpful for many Novice like me.
Ciao
Edika"
   

- Advertisement -