how to import adventureworks database intomysql

#How to import adventureworks database intomysql code

* CHECK FOR DATABASE IF IT DOESN'T EXISTS, DO NOT RUN THE REST OF THE SCRIPT */ PRINT '*** Checking for Database $(DatabaseName)' PRINT '*** Creating Database $(DatabaseName)' RAISERROR('$(DatabaseName) database cannot be dropped because there are still other open connections', 127, 127) WITH NOWAIT, LOG If the database has any other open connections close the network connection. PRINT '*** Dropping Database $(DatabaseName) if exists' PRINT 'Started - ' + CONVERT(varchar, GETDATE(), 121) RAISERROR(N'The variable DatabaseName must be defined.', 16, 127) WITH NOWAIT IF '$(DatabaseName)' IS NULL OR '$(DatabaseName)' = ''

Open the script inside SQL Server Management Studio (SSMS) in the master database

#How to import adventureworks database intomysql code

THIS CODE AND INFORMATION ARE PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND, EITHERĮXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY See these other materials for detailed information regarding This source code is intended only as a supplement to Microsoft Development Tools and/or

This file is part of the Microsoft SQL Server Code Samples.Ĭopyright (C) Microsoft Corporation. Summary: Creates the AdventureWorksDW sample database.