This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
COURSE of the MONTH
12 days, 21 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Server express with Access environment
Posted on 2014-02-19
I've inherited an app that is written in Access 2007 (?) and has linked tables to SQL Server Express .
I'm used to using ODBC drivers to link to Oracle tables on a Windows server running Oracle, but not SQL Server.
I would like to mimic the environment on my desktop that the client has on theirs. I've copied the data using export and that should work, but for my own gratification, I would like to get up to speed on SQL Server Express. This might be the perfect opportunity.
What steps to I need to take to load SQL Server Express?
Is there a way I can export or backup the clients data and import it to my Access mdb?
What's the best way to accomplish this?
I'm used to using ODBC drivers to link to Oracle tables on a Windows server running Oracle, but not SQL Server.
I would like to mimic the environment on my desktop that the client has on theirs. I've copied the data using export and that should work, but for my own gratification, I would like to get up to speed on SQL Server Express. This might be the perfect opportunity.
What steps to I need to take to load SQL Server Express?
Is there a way I can export or backup the clients data and import it to my Access mdb?
What's the best way to accomplish this?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
You need to download and install SQL Server 2008 Express including SQL Server Management Studion
Then restore your backup file using SSMS.
/gustav
Then restore your backup file using SSMS.
/gustav
Active today
You need to first install it:
http://www.microsoft.com/en-us/download/details.aspx?id=29062
The link above is for 2012, but of course there are other versions. Be sure to use the one that is most relevant for you.
Once you do that, the easiest way to move a database is to Backup the database on the Source, and then Restore the database at your machine. You can do that with TSQL, or you can use SQL Server Management Studio. You can install SSMS from here:
http://www.microsoft.com/en-us/download/details.aspx?id=7593
One the source machine, you'd need to create a Backup database, which will create a single file (usually with the .bak extension). Grab that file, and move it over to your machine, and then Restore it to your local SSE install. This article has some further information on the Backup/Restore method:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10138-How-to-upgrade-a-MSSQL-database-from-one-version-to-another.html
Once you do that, you'll have an exact copy of the database from your source.
http://www.microsoft.com/en-us/download/details.aspx?id=29062
The link above is for 2012, but of course there are other versions. Be sure to use the one that is most relevant for you.
Once you do that, the easiest way to move a database is to Backup the database on the Source, and then Restore the database at your machine. You can do that with TSQL, or you can use SQL Server Management Studio. You can install SSMS from here:
http://www.microsoft.com/en-us/download/details.aspx?id=7593
One the source machine, you'd need to create a Backup database, which will create a single file (usually with the .bak extension). Grab that file, and move it over to your machine, and then Restore it to your local SSE install. This article has some further information on the Backup/Restore method:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10138-How-to-upgrade-a-MSSQL-database-from-one-version-to-another.html
Once you do that, you'll have an exact copy of the database from your source.
Active today
Hi,
backups and detach/attach methods are good if you only want to copy a database in one direction. But if you also want to develop this database and then move your developments back to the production server you can't do this with backup or detach/attach because you would of course destroy the data which was added in the meantime.
So you should consider to install a deployment tool for this job which can also copy the production database to your machine (and this can also be done from an enterprise version to an express version or vice-versa).
Here's a good one which is free:
Atlantis Schema Inspector
and also:
Atlantis Data Inspector
Of course the better one is the Redgate SQL Toolbelt but also not very cheap.
Cheers,
Christian
backups and detach/attach methods are good if you only want to copy a database in one direction. But if you also want to develop this database and then move your developments back to the production server you can't do this with backup or detach/attach because you would of course destroy the data which was added in the meantime.
So you should consider to install a deployment tool for this job which can also copy the production database to your machine (and this can also be done from an enterprise version to an express version or vice-versa).
Here's a good one which is free:
Atlantis Schema Inspector
and also:
Atlantis Data Inspector
Of course the better one is the Redgate SQL Toolbelt but also not very cheap.
Cheers,
Christian
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security
- Security, *Phishing
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month12 days, 21 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.