[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

how can i import and export data from SQL Server 2005 Express?

Posted on 2007-08-07
6
Medium Priority
?
655 Views
Last Modified: 2013-11-05
how can i import and export data from SQL Server 2005 Express? as some service providers say that you can use advance services for this.
0
Comment
Question by:apnamian
  • 2
  • 2
  • 2
6 Comments
 
LVL 11

Expert Comment

by:cmhunty
ID: 19647301
If you have Access, you can connect to the SQL Server table as a linked table. From there you can import data into that table as you would in Access.

0
 
LVL 11

Expert Comment

by:cmhunty
ID: 19647330
And as this is in the ASP.NET subject too......

You can use ADO.NET in an ASP.NET page to access the data you wish to import and write insert statements and run those on the server. :-)
0
 
LVL 3

Author Comment

by:apnamian
ID: 19647441
Sorry brother i asked the question in the point of view os a database admin.
to take back up and restore the db as we do in standard edition of the sql server.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 14

Accepted Solution

by:
chinu1310 earned 2000 total points
ID: 19647643
0
 
LVL 3

Author Comment

by:apnamian
ID: 19653011
does this mean that i can take the backup of my database and can export or import it to MS SQL Server 2005?
0
 
LVL 14

Expert Comment

by:chinu1310
ID: 19655681
Yeah sure. They provide this kind of tools and functionality.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question