1
vote
1answer
33 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
1
vote
1answer
24 views

Migrating from SQL 2008 to SQl express on the same VM

I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
1
vote
3answers
213 views

How Do I Migrate 100 DBs From One MS-SQL 2008 Server To Another? (looking for automation)

Let me start by saying that I am not a DBA, but I am in a position where I am responsible for moving just under 100 MS-SQL 2008 DBs from our current development server, to a new/better/faster ...
0
votes
1answer
280 views

Convert MYSQL DATABASE TO MSSQL DATABASE [closed]

I would like to ask if there is a software that convert all my database from mysql to mssql 2008
4
votes
4answers
2k views

How to create a SQL Server database from a mysqldump file automatically on a daily basis?

Recently, a vendor announced that they were upgrading their processes, and an automated, daily data dump we are getting from them will now come in a MySQL datadump format. Unfortunately, we're a ...
1
vote
2answers
357 views

SQL Server Express - Move by Copying Data Folder?

We are moving our SQL Server to new hardware. Initially we were going to do this simply via backup and restore, but noticed we'd have to recreate all the logins. We don't want to do that :) ...
2
votes
4answers
766 views

How to change storage location of a database?

my hard-drive is currently almost full!! I need to migrate the db to a different drive, how can I do this? They are all stored in the default C:\ drive. Any ideas?
1
vote
1answer
539 views

Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the ...