ASP.NET WEB HOSTING. Fast windows web hosting at discount prices. Microsoft Windows 2008 server hosting. web site hoting Home    web hosting asp net Login  

Search FAQ-Home Ask question Help

 Categories

· Show all categories

FTP
Front Page
Email
Web Site
Domain Name
MySQL
MS Access
E-Commerce
Hosting
ASP
ASP.NET
PHP
Buy Hosting Account
Upgrade
Billing
Others
PERL
CodeBank
MS SQL
Virtual Private Server

· FAQ-Home


Question:  MS SQL:
Is there any way to move or change my file based databases to server based databases without loosing data? How I can do it?



Answer:   1. Use your local MS SQL Management Studio and export the local SQL database in SQL file.

2. Create a new server based SQL database by using your Control Panel -> MSSQL section.

3. Connect with your local MS SQL Management Studio to the Remote Database that you have just created.

4. Open a new query on the database and copy and past the content of the exported SQL file in that new query.

5. If there is a line in the SQL query that refers to creating new database - just remove that line ( because your database is already created, it is just empty database ) and then execute the query against the remote database.

This will create your database tables and fill them with the existing data.



Last update: 2011-10-06 10:24
Author: admin

printer-friendly version Send to a friend
Show this as PDF file export as XML-File

Average rating: 2.85 from 5 (889 Votes )

Please rate this entry:
completely
useless

1

2

3

4

5
most
valuable
You cannot comment on this entry | Content Overview: MS SQL
  WINDOWS WEB HOSTING | ASP.NET HOSTING | WEB HOSTING | WINDOWS 2003 HOSTING PLANS
TERMS OF SERVICE |  CONTACT  |  PRIVACY POLICYHOMEMASTERCARDDISCOVERAMERICAN EXPRESSPAYPAL
Copyright BIZHOSTNET.COM All rights reserved.  All trademarks are property of their legal owners.
BIZHOSTNET.COM is a web hosting company specializing in the following Web Hosting Products:
Windows Hosting Windows Hosting Windows 2008 Hosting Windows 2003 Hosting Windows 2008 Hosting Windows 2008 Hosting Frame .NET Hosting Frame .NET Hosting ASP Hosting ASP Hosting ASP Web Hosting ASP Web Hosting ASP.NET Hosting ASP.NET Hosting ASP.NET 4.0 Hosting ASP.NET 4.0 Hosting ASP.NET 3.5 Hosting ASP.NET 3.5 Hosting ASP.NET 2.0 Hosting ASP.NET 2.0 Hosting ASP.NET 1.1 Hosting ASP.NET 1.1 Hosting Microsoft Frontpage Hosting Microsoft Frontpage Hosting PHP Hosting PHP Hosting PERL and CGI Web Hosting PERL and CGI Web Hosting DOMAIN NAMES STATUS CODE Domain Names Status Free Domain names Free Domain names
Free MySQL Database Free MySQL Database Free SQL Database Free SQL Database