SQL ->SQL DATABASE Conversion steps

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

General SQL Server Forums

New to SQL Server Programming

SQL ->SQL DATABASE Conversion steps

Author

Topic

kranthimavin
Starting Member

1 Post

Posted - 2006-12-22 : 03:01:37

Hi all,
Can any one help me in this issue?I am new for this SQL server.By creating scripts from server system.I got the tables without data in my system.But i want to get the full database as usual there in server.
I have to convert my existing MS Access frontend and SQL backend app into ASP.NET web app with sql server backend.The version is 2000.Pls it's urgent?

Kranthi

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2006-12-22 : 03:15:43

what i understand is u want to create a new database from a existing database. best way is to take a backup of the source database and then use RESTORE WITH MOVE option to restore with some other name.

Refer BACKUP,RESTORE with MOVE in BOL

Eg.

Backup database databaseName to DISK='C:\test.bak' -- Backing up the database

RESTORE FILELISTONLY
FROM DISK = 'D:\GPXDevlopment1.bak'

RESTORE DATABASE <NewDatabaseName>
FROM DISK = 'C:\Test.bak'
WITH MOVE 'SourceDatabaseMdFname' TO 'D:\GPxData\GPx.mdf',
MOVE 'SourceDBLogName' TO 'D:\GPxData\GPx_log.ldf'

Madhu

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-22 : 03:18:01

1 If you create scripts, you wont have data
2 You have to take backup and restore it when needed

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources