The feature is part of Access not SQL server. It is easy to do manually.
Create the database manually, then right-click the DB and choose Task|Import
Data, drill into your Access DB and import the tables. Once imported you can
create a Database diagram since all constraints will now be handled by SQL
server. (make sure you key all of the tables)
Then create an ODBC file DSN for this database connection, then fire up the
Access database and right-click in the 'Tables' window, choose Link Tables,
choose ODBC Databases() and then choose the DSN you created and finally all
of the tables you need to link.
You'll want to rename the old tables to "tableName_old" then rename the
linked tables removing the "dbo_" from the table names.
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows] http://www.microsoft.com/protect
"Alex Maghen" wrote:
| In SQL Server 2000 there was a feature for "upsizing" MS Access database
| files into SQL Server Databases. Is this still around in 2005? I can't
find
| it and BOY do I need it.
|
| Alex
Re: MS Access DAO -> ADO.NET Migration ... William Vaughn...Microsoft MVP... Hitchhiker's Guide to Visual Studio and SQL Server... My migration app works building a SSCE database file with imported data ... (microsoft.public.dotnet.framework.adonet)
Re: Renaming DB ... As Kevin mentioned, you must detach the database, move the file, then reattach. ... you can only rename o/s files for tempdb and then it only takes effect after a restart. ... The new tempdb file name takes effect only after SQL Server is stopped and restarted. ... If the file is on a raw partition, os_file_name must specify only the drive letter of an existing raw partition. ... (microsoft.public.sqlserver.setup)
Re: Cluster will not fail over. ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database.... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ... (microsoft.public.sqlserver.clustering)
Re: MS Access DAO -> ADO.NET Migration ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ... (microsoft.public.dotnet.framework.adonet)
Re: MS Access DAO -> ADO.NET Migration ... For that it is much harder to handle the incremental identifier,...database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ...SQL Server Management Studio is nowhere to be found on my ... (microsoft.public.dotnet.framework.adonet)
